Oracle Data Pump Import and Export

1. First establish Dump_dir Sqlplus/as SYSDBA

SELECT * FROM Dba_directories

If there is no Dump_dir, execute the following statement

CREATE OR REPLACE directory dump_dir as ' C:\as ' where the "C:\as" is the Dump_dir catalog, used to store DMP files

2. Execute the following statement authorizing Grant READ, WRITE on DIRECTORY SYS. Dump_dir to SYSTEM

3. Import, export cmd under Execute the following command set oracle_sid = xxx xxx for db instance name

Import change the DMP file to Dbname.dmp and then put the "C:\as" in the directory set in step 1 and execute the following statement directly in CMD, and drop user dbname cascade IMPDP If dbname is already present. Test1 directory=dump_dir schemas=dbname dumpfile =dbname.dmp logfile=impdbname.log

The Export command is EXPDP system/information directory=dump_dir schemas=dbname dumpfile=dbname.dmp logfile=expdbname.log and then "C:\as" Locate the DMP file in the directory

Oracle Data Pump Import and Export