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