[20150126]datadump的非文档参数.txt

--总结一下expdp/impdp的非文档参数:

1. METRICS
METRICS=Y ,记录执行详细的执行时间.例子:

$ expdp scott/btbtms DIRECTORY=DATA_PUMP_DIR  DUMPFILE=emp012601.dmp LOGFILE=emp012601.log tables=emp metrics=y
Export: Release 11.2.0.3.0 - Production on Mon Jan 26 10:03:22 2015
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/a* DIRECTORY=DATA_PUMP_DIR DUMPFILE=emp012601.dmp LOGFILE=emp012601.log tables=emp metrics=y
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
     Completed 1 TABLE objects in 0 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/INDEX/INDEX
     Completed 3 INDEX objects in 2 seconds
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
     Completed 1 CONSTRAINT objects in 0 seconds
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
     Completed 3 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/INDEX/BITMAP_INDEX/INDEX
     Completed 1 INDEX objects in 0 seconds
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
     Completed 1 INDEX_STATISTICS objects in 0 seconds
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
     Completed 1 TABLE_STATISTICS objects in 0 seconds
Processing object type TABLE_EXPORT/TABLE/STATISTICS/USER_PREF_STATISTICS
     Completed 1 USER_PREF_STATISTICS objects in 1 seconds
. . exported "SCOTT"."EMP"                               8.976 KB      14 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/emp012601.dmp
Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 10:03:36

2.ACCESS_METHOD

--这个参数缺省无需指定,oracle会选择合适***的加载与卸载方式.
--有兴趣可以看看我以前写的expdp与行迁移.
http://blog.itpub.net/267265/viewspace-1078757/

--可以使用access_method=external_table加快存在行迁移的表导出.

3. TRACE
--使用7位的十六进制数表示.前3位表示特定的DataPump component,后4位通常都是0300,前面的0可以省略.大小写不敏感.输出信息在相
--应的跟踪文件,而不是导出的日志文件.

  10300 SHDW: To trace the Shadow process
  20300 KUPV: To trace Fixed table
  40300 'div' To trace Process services
  80300 KUPM: To trace Master Control Process
100300 KUPF: To trace File Manager
200300 KUPC: To trace Queue services
400300 KUPW: To trace Worker process(es)        
800300 KUPD: To trace Data Package
1000300 META: To trace Metadata Package
1FF0300 'all' To trace all components, full tracing

--例子:

$ expdp scott/btbtms DIRECTORY=DATA_PUMP_DIR  DUMPFILE=emp012601.dmp LOGFILE=emp012601.log tables=emp trace=1FF0300

Export: Release 11.2.0.3.0 - Production on Mon Jan 26 09:13:03 2015

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/a*** DIRECTORY=DATA_PUMP_DIR DUMPFILE=emp012601.dmp LOGFILE=emp012601.log tables=emp trace=1FF0300
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 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/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/INDEX/BITMAP_INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/USER_PREF_STATISTICS
. . exported "SCOTT"."EMP"                               8.976 KB      14 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/emp012601.dmp
Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 09:13:18

$ cd /u01/app/oracle11g/diag/rdbms/test/test/trace
$ ls -ltr *.trc | grep "2015-01-26 09:13:"
-rw-r-----  1 oracle11g oinstall     1073 2015-01-26 09:13:05 test_dm00_10649.trc
-rw-r-----  1 oracle11g oinstall     1033 2015-01-26 09:13:06 test_dw00_10651.trc
-rw-r-----  1 oracle11g oinstall   150558 2015-01-26 09:13:18 test_dw00_10651_127_0_0_1.trc
-rw-r-----  1 oracle11g oinstall    25430 2015-01-26 09:13:19 test_ora_10647_127_0_0_1.trc
-rw-r-----  1 oracle11g oinstall    47714 2015-01-26 09:13:19 test_dm00_10649_127_0_0_1.trc

4.KEEP_MASTER

--使用KEEP_MASTER=Y ,可以在完成后不删除master table,也就是SYS_EXPORT_TABLE_*表.

SCOTT@test> desc SYS_EXPORT_TABLE_01
ERROR:
ORA-04043: object SYS_EXPORT_TABLE_01 does not exist

$ expdp scott/btbtms DIRECTORY=DATA_PUMP_DIR  DUMPFILE=emp012601.dmp LOGFILE=emp012601.log tables=emp KEEP_MASTER=Y
...

SCOTT@test> @desc SYS_EXPORT_TABLE_01
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
PROCESS_ORDER                                      NUMBER
DUPLICATE                                          NUMBER
DUMP_FILEID                                        NUMBER
DUMP_POSITION                                      NUMBER
DUMP_LENGTH                                        NUMBER
DUMP_ORIG_LENGTH                                   NUMBER
DUMP_ALLOCATION                                    NUMBER
COMPLETED_ROWS                                     NUMBER
ERROR_COUNT                                        NUMBER
ELAPSED_TIME                                       NUMBER

--可以发现SYS_EXPORT_TABLE_01没有删除.