[20130325]KEEP_MASTER and METRICS in EXPDPIMDP.txt

[20130325]KEEP_MASTER and METRICS in EXPDPIMDP.txt

"KEEP_MASTER" and "METRICS"是兩個未文件的引數。
METRICS提供處理物件的計時,KEEP_MASTER用來保留Data Pump Master table，不刪除它。

1.沒有兩個引數的情況:

$ expdp scott/btbtms directory=DATA_PUMP_DIR dumpfile=test1.dmp logfile=test1.log tables=dept,emp

Export: Release 11.2.0.3.0 - Production on Mon Mar 25 15:54:52 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Starting "SCOTT"."SYS_EXPORT_TABLE_01":  scott/******** directory=DATA_PUMP_DIR dumpfile=test1.dmp logfile=time1.log */

tables=dept,emp

Estimate in progress using BLOCKS method...

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 128 KB

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type TABLE_EXPORT/TABLE/AUDIT_OBJ

Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type TABLE_EXPORT/TABLE/STATISTICS/USER_PREF_STATISTICS

. . exported "SCOTT"."DEPT"                              5.968 KB       6 rows

. . exported "SCOTT"."EMP"                               8.601 KB      15 rows

Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:

  /u01/app/oracle11g/admin/test/dpdump/test1.dmp

Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 15:55:06

2.使用metrics引數:

$ expdp scott/xxxx directory=DATA_PUMP_DIR dumpfile=test1.dmp logfile=test1.log tables=dept,emp metrics=y

$ expdp scott/btbtms directory=DATA_PUMP_DIR dumpfile=test1.dmp logfile=test1.log tables=dept,emp metrics=y

Export: Release 11.2.0.3.0 - Production on Mon Mar 25 15:56:46 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Starting "SCOTT"."SYS_EXPORT_TABLE_01":  scott/******** directory=DATA_PUMP_DIR dumpfile=test1.dmp logfile=test1.log */

tables=dept,emp metrics=y

Estimate in progress using BLOCKS method...

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 128 KB

Processing object type TABLE_EXPORT/TABLE/TABLE

     Completed 2 TABLE objects in 2 seconds

     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

     Completed 1 OBJECT_GRANT objects in 2 seconds

Processing object type TABLE_EXPORT/TABLE/AUDIT_OBJ

     Completed 1 AUDIT_OBJ objects in 0 seconds

Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

     Completed 5 INDEX objects in 2 seconds

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

     Completed 2 CONSTRAINT objects in 0 seconds

Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

     Completed 5 INDEX_STATISTICS objects in 0 seconds

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

     Completed 1 REF_CONSTRAINT objects in 1 seconds

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

     Completed 2 TABLE_STATISTICS objects in 0 seconds

Processing object type TABLE_EXPORT/TABLE/STATISTICS/USER_PREF_STATISTICS

     Completed 2 USER_PREF_STATISTICS objects in 0 seconds

. . exported "SCOTT"."DEPT"                              5.968 KB       6 rows

. . exported "SCOTT"."EMP"                               8.601 KB      15 rows

Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:

  /u01/app/oracle11g/admin/test/dpdump/test1.dmp

Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 15:56:58

3.使用KEEP_MASTER引數:

$ expdp scott/btbtms directory=DATA_PUMP_DIR dumpfile=test1.dmp logfile=test1.log tables=dept,emp KEEP_MASTER=y

Export: Release 11.2.0.3.0 - Production on Mon Mar 25 15:59:43 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Starting "SCOTT"."SYS_EXPORT_TABLE_01":  scott/******** directory=DATA_PUMP_DIR dumpfile=test1.dmp logfile=test1.log */

tables=dept,emp KEEP_MASTER=y

Estimate in progress using BLOCKS method...

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 128 KB

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type TABLE_EXPORT/TABLE/AUDIT_OBJ

Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type TABLE_EXPORT/TABLE/STATISTICS/USER_PREF_STATISTICS

. . exported "SCOTT"."DEPT"                              5.968 KB       6 rows

. . exported "SCOTT"."EMP"                               8.601 KB      15 rows

Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:

  /u01/app/oracle11g/admin/test/dpdump/test1.dmp

Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 15:59:54

如果在執行一次，就產生"SCOTT"."SYS_EXPORT_TABLE_02" 表。

以SCOTT使用者登入，能發現這些表SYS_EXPORT_TABLE_01。