Oracle 10.2.0.5 RAC on AIX 6.1
SQL> select count(*) from comm.apply_sheet;
COUNT(*)
----------
55618696
;;;
Export: Release 10.2.0.5.0 - 64bit Production on Friday, 23 March, 2018 15:00:47
Copyright (c) 2003, 2007, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Starting "***********"."NODE2FULL": ************/******** DIRECTORY=dpwin DUMPFILE=full.dmp logfile=expdp_.log JOB_NAME=node2full Tables=COMM.APPLY_SHEET
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 14.20 GB
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/STATISTICS/TABLE_STATISTICS
. . exported "COMM"."APPLY_SHEET" 12.31 GB 57078721rows
Master table "************"."NODE2FULL" successfully loaded/unloaded
******************************************************************************
Dump file set for *************.NODE2FULL is:
/mnt/win/dump/full.dmp
Job "********"."NODE2FULL" successfully completed at 15:03:56
命令很简单,没加什么多余的参数
expdp *********/******* DIRECTORY=dpwin DUMPFILE=full.dmp logfile=expdp_.log JOB_NAME=node2full Tables=COMM.APPLY_SHEET
57078721 - 55618696 导出来的内容居然比原始数据多出146万行!!
求排查思路