[20130325]KEEP_MASTER and METRICS in EXPDPIMDP.txt

lfree發表於2013-03-25
AST
[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。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/267265/viewspace-757013/，如需轉載，請註明出處，否則將追究法律責任。

相關文章