Oracle expdp/impdpó?·¨

<!--[if !supportLists]-->1.       <!--[endif]-->Go to the oracle server AMX currently used, execute

[oracle@lnxas4-ce2 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jan 12 07:18:47 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect /as sysdba

Connected.

SQL> create or replace directory bakdir as /home/oracle/bak;

Directory created.

SQL> grant read,write on directory bakdir to qsh05;   

Grant succeeded.

SQL> exit
 

/home/oracle/bak is where to save database dump file, and ??qsh05?ˉ is database username.

<!--[if !supportLists]-->2.       <!--[endif]-->Make sure /home/oracle/bak is created, then execute

expdp qsh05/qsh05 dumpfile=qsh05.dmp directory=bakdir include=table
 

??qsh05/qsh05?ˉ is database username/password, and ??dumpfile?ˉ is the file name of database dump file, and ??directory?ˉ is the directory name created in step 1, because only need export table, so add ??include=table?ˉ.

<!--[if !supportLists]-->3.       <!--[endif]-->If the export is successful, the end of log looks like following,

Dump file set for QSH05.SYS_EXPORT_SCHEMA_01 is:

  /home/oracle/bak/qsh05.dmp

Job "QSH05"."SYS_EXPORT_SCHEMA_01" successfully completed at 07:25:30
 

and go to /home/oracle/bak, there are two files, ??qsh05.dmp?ˉ and ??export.log?ˉ.

<!--[if !supportLists]-->4.       <!--[endif]-->Go to the ORACLE server where the AMX wanted to migrate, and create a new user/password in database.

<!--[if !supportLists]-->5.       <!--[endif]-->Create a new dir, and create a new directory mapping to this dir as step 1.

<!--[if !supportLists]-->6.       <!--[endif]-->Copy dump file to the dir created in step 5, then execute

impdp new_user/new_pass remap_schema=qsh05:new_user dumpfile=qsh05.dmp directory=new_directory include=table
 

<!--[if !supportLists]-->7.       <!--[endif]-->If the import is successful, the end of log looks like following,

Job "QSH07"."SYS_IMPORT_FULL_01" successfully completed at 17:46:55