1、1：记录源库用户规则导出库：1 SA REMOTE320DB TEMP DEFAULT2 ZXX REMOTE320DB TEMP DEFAULT
2、2：进行用户导出create directory dump_dir as '/home/oracle/dir_dump';grant read,write on directory dump_dir to zxx;expdp zxx/zxx schemas=sa directory=dump_dir parallel=6 dumpfile=sa_20150922_U.dmp logfile=sa_20150922.logorcl:/home/oracle@jkdb>expdp zxx/zxx schemas=sa directory=dump_dir parallel=6 dumpfile=sa_20150922_U.dmp logfile=sa_20150922.logExport: Release 11.2.0.3.0 - Production on Wed Sep 23 09:02:08 2015Copyright (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 ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsStarting "ZXX"."SYS_EXPORT_SCHEMA_01": zxx/******** schemas=sa directory=dump_dir parallel=6 dumpfile=sa_20150922_U.dmp logfile=sa_20150922.logEstimate in progress using BLOCKS method...Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 13.72 GBProcessing object type SCHEMA_EXPORT/USERProcessing object type SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_GRANTProcessing object type SCHEMA_EXPORT/DEFAULT_ROLEProcessing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCEProcessing object type SCHEMA_EXPORT/TABLE/TABLEProcessing object type SCHEMA_EXPORT/TABLE/COMMENTProcessing object type SCHEMA_EXPORT/PROCEDURE/PROCEDUREProcessing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDUREProcessing object type SCHEMA_EXPORT/TABLE/INDEX/INDEXProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICSProcessing object type SCHEMA_EXPORT/VIEW/VIEWProcessing object type SCHEMA_EXPORT/TABLE/TRIGGERProcessing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICSProcessing object type SCHEMA_EXPORT/JOBORA-39126: Worker unexpected fatal error in KUPW$WORKER.MAIN [TABLE_DATA:"SA"."DLJK_ZPXX"] ---->DLJK_ZPXX读取报错ORA-24795: Illegal ROLLBACK attempt madeORA-06512: at "SYS.KUPW$WORKER", line 9826ORA-24795: Illegal ROLLBACK attempt madeORA-06512: at "SYS.KUPW$WORKER", line 3340ORA-24795: Illegal ROLLBACK attempt madeORA-24795: Illegal ROLLBACK attempt madeORA-06512: at "SYS.KUPW$WORKER", line 15486ORA-02354: error in exporting/importing dataORA-01115: IO error reading block from file (block # )ORA-01115: IO error reading block from file 5 (block # 5506)ORA-27072: File I/O errorAdditional information: 4Additional information: 5506Additional information: 843776ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95ORA-06512: at "SYS.KUPW$WORKER", line 9001----- PL/SQL Call Stack ----- object line object handle number name0x1583c3940 20462 package body SYS.KUPW$WORKER0x1583c3940 9028 package body SYS.KUPW$WORKER0x1583c3940 1829 package body SYS.KUPW$WORKER0x156869098 2 anonymous blockJob "ZXX"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 09:15:07可以看到报错很明显，DLJK_ZPXX表读取报错，在plsql查询时，发现数据文件损坏。但是还能够查询到部分数据。
3、3：导出时过滤问题表expdp zxx/zxx schemas=sa directory=dump_dir parallel=6 dumpfile=sa_20150923_U.dmp EXCLUDE=TABLE:\"IN \(\'DLJK_ZPXX\' \)\" logfile=sa_20150922.log;发现还是报错，可以看到DLJK_CLGJXX部分数据读取报错。通过一个一个排除，发现只有两张大表有问题。只能够把两张表过滤掉了。expdp zxx/zxx schemas=sa directory=dump_dir parallel=6 dumpfile=sa_20150923_U.dmp EXCLUDE=TABLE:\"IN \(\'DLJK_ZPXX\' ,\'DLJK_CLGJXX\'\)\" logfile=sa_20150922.log;
4、4：通过query导出问题表的正常部分数据1：首先通过query导出问题表的部分数据和表结构，这时候CONTENT=ALL2：然后通过query导出问题表的其他部分正常数据，这时候CONTENT=DATA_ONLY数据导入很简单，这里不做讲诉了。