ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle 10g Data Pump

Oracle 10g Data Pump

原创 Linux操作系统 作者:annnnna 时间:2009-09-08 15:13:52 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
下一篇: Killing DBMS_JOB
请登录后发表评论 登录
全部评论

注册时间:2009-09-04

  • 博文量
    23
  • 访问量
    12525