[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。