Oracle uses data pump to import Export data ____oracle

Objective: To export a database on a computer and import it into a database on another computer using a data pump.

A the operation on the computer. EXPDP Data export

1, running CMD;

2, login database, input command: sqlplus system/password;

3, creating directory path: Create directory Backup_path as ' E:\APP\TWS\ORADATA\ORCLDV '; (Backup_path is a path name, can be named (must be an existing path), E:\APP\TWS\ORADATA\ORCL is the source database path)

5, Import Export Operation authorization: Grant Exp_full_database,imp_full_database to Dmuser; (Dmuser is the database user name)

6, exit: Exit;

7, data export, execute command:EXPDPdmuser/***** directory=backup_path dumpfile=dmuser_schema.dmp logfile=dmuser_schema_29. Log (Dmuser for username, * * * for password, dmuser_schema.dmp for export database file, can be named, but format to be. Dmp,dmuser_schema_29.log as log file, can be named)

b The operation on the computer. IMPDP Data import

Copy the exported database files to the destination database path.

1, running CMD;

2, login database, input command: sqlplus system/password;

3, creating directory path: Create directory Goup_path as ' E:\APP\TWS\ORADATA\ORCL '; (Goup_path is the path name, can be named, E:\APP\TWS\ORADATA\ORCL is the target database path)

4, exit: Exit;

5, data import, execute the command:IMPDPdmuser/***** directory=goup_path dumpfile=dmuser_schema.dmp logfile=dmuser_schema_29. Log

Reference Documentation:

Http://www.cnblogs.com/jyzhao/p/4530575.html

http://blog.csdn.net/fjseryi/article/details/50013961

http://blog.itpub.net/23490154/viewspace-1061687/

http://blog.csdn.net/haiross/article/details/27580199/