Oracle 10g Data Pump

Oracle introduced Data Pump in Oracle Database 10g Release 1.  Oracle Data Pump is a newer,  faster and more flexible alternative to the "exp" and "imp" utilities used in previous Oracle versions.

 

Getting Started

 

Note: If you have no EXP_FULL_DATABASE role, you can only export your own schema. If you have EXP_FULL_DATABASE role, you can export several schemas in one go.

 

SQL> connect / as sysdba
SQL> GRANT CREATE ANY DIRECTORY TO scott;
SQL> CREATE OR REPLACE DIRECTORY test_dir AS '/u01/app/oracle/oradata/';
SQL> GRANT READ, WRITE ON DIRECTORY test_dir TO scott;

 

Table Exports/Imports

 

expdp scott/tiger@db10g  tables=EMP,DEPT  directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=expdpEMP_DEPT.log

 

impdp scott/tiger@db10g  tables=EMP,DEPT directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=impdpEMP_DEPT.log

 

expdp scott/tiger@db10g  schemas=SCOTT include=TABLE:"IN ('EMP', 'DEPT')" directory=TEST_DIR dumpfile=SCOTT.dmp logfile=expdpSCOTT.log

 

expdp scott/tiger@db10g  schemas=SCOTT exclude=TABLE:"= 'BONUS'" directory=TEST_DIR dumpfile=SCOTT.dmp logfile=expdpSCOTT.log

 

The  TABLE_EXISTS_ACTION=APPEND/REPLACE  parameter allows data to be imported into existing tables.

 

Schema Exports/Imports

 

expdp scott/tiger@db10g  schemas=SCOTT directory=TEST_DIR dumpfile=SCOTT.dmp logfile=expdpSCOTT.log

 

impdp scott/tiger@db10g  schemas=SCOTT directory=TEST_DIR dumpfile=SCOTT.dmp logfile=impdpSCOTT.log

 

Database Exports/Imports

 

expdp scott/tiger@db10g  full=Y directory=TEST_DIR dumpfile=DB10G.dmp logfile=expdpDB10G.log

 

impdp scott/tiger@db10g  full=Y directory=TEST_DIR dumpfile=DB10G.dmp logfile=impdpDB10G.log

 

Check Job Status

 

SQL> select * from DBA_DATAPUMP_JOBS;
SQL> select * from DBA_DATAPUMP_SESSIONS;
SQL> select * from dba_directories;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22473175/viewspace-614168/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22473175/viewspace-614168/