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/