1.数据导出时的日志

;;; Export: Release 11.2.0.3.0 - Production on Thu Jan 21 11:13:33 2016Copyright (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, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionsStarting "SYSTEM"."SYS_EXPORT_TABLE_02":  system/******** tables=zen.zentest dumpfile=teste_SZ2015.dmp logfile=test_SZ2015.log Estimate in progress using BLOCKS method...Processing object type TABLE_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 19.85 GBProcessing object type TABLE_EXPORT/TABLE/TABLEProcessing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS. . exported "ZEN"."ZENTEST"            17.59 GB 105862326 rowsMaster table "SYSTEM"."SYS_EXPORT_TABLE_02" successfully loaded/unloaded******************************************************************************Dump file set for SYSTEM.SYS_EXPORT_TABLE_02 is:  /u01/app/oracle/11.2.0/db_1/rdbms/log/ZENTEST.dmpJob "SYSTEM"."SYS_EXPORT_TABLE_02" successfully completed at 11:21:26

2.导入时报错

D:\OracleBase\dpdump_dir>impdp \"sys/oracle as sysdba \" directory=dpdump_dir DUMPFILE=ZENTEST.dmp logfile=impdp.log PARALLEL=5Import: Release 11.2.0.1.0 - Production on 星期一 2月 1 10:14:51 2016Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options已成功加载/卸载了主表 "SYS"."SYS_IMPORT_FULL_01"启动 "SYS"."SYS_IMPORT_FULL_01":  "sys/******** AS SYSDBA" directory=dpdump_dir DUMPFILE=ZENTEST.dmp logfile=impdp.log PARALLEL=5处理对象类型 TABLE_EXPORT/TABLE/TABLE处理对象类型 TABLE_EXPORT/TABLE/TABLE_DATAORA-31693: 表数据对象 "ZEN"."ZENTEST" 无法加载/卸载并且被跳过, 错误如下:ORA-29913: 执行 ODCIEXTTABLEOPEN 调出时出错处理对象类型 TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS作业 "SYS"."SYS_IMPORT_FULL_01" 已经完成, 但是有 1 个错误 (于 10:14:53 完成)D:\OracleBase\dpdump_dir>

3.导出时的版本比导入的版本略高，开始想到的是，是不是impdp/expdp版本的问题，

google了下 得到下面的说法。

With expdp, the COMPATIBLE parameter does not exist: it is VERSION. This parameter is intended to export/import dump between database version (for example between 10g and 11g).Since you are running 11.2.0.x on both side, no need to be concerned of any compatibility.

4.于是继续Google 。说是设置了并行参数的问题。

于是去掉并行参数重新导入

D:\OracleBase\dpdump_dir>impdp \"sys/oracle as sysdba \" directory=dpdump_dir DUMPFILE=ZENTEST.dmp logfile=impdp.log

Import: Release 11.2.0.1.0 - Production on 星期一 2月 1 10:28:11 2016  Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. 连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options 已成功加载/卸载了主表 "SYS"."SYS_IMPORT_FULL_01" 启动 "SYS"."SYS_IMPORT_FULL_01": "sys/******** AS SYSDBA" directory=dpdump_dir DUMPFILE=testzen.dmp logfile=impdp.log 处理对象类型 TABLE_EXPORT/TABLE/TABLE 处理对象类型 TABLE_EXPORT/TABLE/TABLE_DATA . . . .

果然 好使了。

5.但是同样的文件在11.2.0.4.0 上导入就可以设置并行参数，这一点没有搞明白。