Data Pump export Oracle 10g database

First connect the Sqlplus:

Sqlplus/nolog

Conn System/manager

1. Manually create a directory to hold the exported DMP file

Create or replace directory Whboa as ' E:\oracleDate\dmp ';

2. Authorizing the Catalog

Grant Read,write on directory Whboa to public;

3. Exit Sqlplus Connection

4. Export, note If the exported import database is not the same version, note that when exporting, add the version number

EXPDP ' whboa/[email protected] ' Directory=whboa dumpfile=whboaexpdp.dmp version =;

Data Pump export Oracle 10g database