在一次使用数据泵导出/导入工具(expdp/impdp),进行数据库数据迁移时,执行impdp命令时,发生了ora-600的错误,导致了部分表导入失败.经查,表的定义信息被导入,表的记录数为0.查询了metalink的相关文件,只找到关于导出时使用了压缩导致的问题,本例中导出是没有使用压缩的,所以不属于这种情况。

本例中导出是使用的文件分割，即在expdp命令中使用了filesize＝10g的参数。

导出的语句和错误如下:

$impdp system/*** dumpfile=full_20110301_%U.dmp directory=imp_dir logfile=imp01.log

。。。。。。

ORA-31693: Table data object "DATA_QUALITY"."STRATEGY_3471" failed to load/unload and is being skipped due to error:

ORA-02354: error in exporting/importing data

ORA-39776: fatal Direct Path API error loading table "DATA_QUALITY"."STRATEGY_3471"

ORA-00600: internal error code, arguments: [klaprs_11], [], [], [], [], [], [], []

ORA-31693: Table data object "DATA_QUALITY"."STRATEGY_6947" failed to load/unload and is being skipped due to error:

ORA-02354: error in exporting/importing data

ORA-39776: fatal Direct Path API error loading table "DATA_QUALITY"."STRATEGY_6947"

ORA-00600: internal error code, arguments: [klaprs_11], [], [], [], [], [], [], []

ORA-31693: Table data object "DATA_QUALITY"."STRATEGY_3346" failed to load/unload and is being skipped due to error:

ORA-02354: error in exporting/importing data

ORA-39776: fatal Direct Path API error loading table "DATA_QUALITY"."STRATEGY_3346"

ORA-00600: internal error code, arguments: [klaprs_11], [], [], [], [], [], [], []

ORA-31693: Table data object "DATA_QUALITY"."STRATEGY_3351" failed to load/unload and is being skipped due to error:

ORA-02354: error in exporting/importing data

ORA-39776: fatal Direct Path API error loading table "DATA_QUALITY"."STRATEGY_3351"

ORA-00600: internal error code, arguments: [klaprs_11], [], [], [], [], [], [], []

ORA-31693: Table data object "DATA_QUALITY"."STRATEGY_3473" failed to load/unload and is being skipped due to error:

ORA-02354: error in exporting/importing data

ORA-39776: fatal Direct Path API error loading table "DATA_QUALITY"."STRATEGY_3473"

ORA-00600: internal error code, arguments: [klaprs_11], [], [], [], [], [], [], []

在目标库，这些出错的表都已经存在了,所以需要先删除,具体SQL语句如下:

Drop table data_quality.STRATEGY_3471 Purge;

Drop table data_quality.STRATEGY_6947 Purge;

Drop table data_quality.STRATEGY_3346 Purge;

Drop table data_quality.STRATEGY_3351 Purge;

Drop table data_quality.STRATEGY_3473 Purge;

在源库上重新导出发生错误的表:

expdp system/****** dumpfile=part.dmp directory=dmp_dir tables=data_quality.STRATEGY_3471,data_quality.STRATEGY_6947,data_quality.STRATEGY_3346,data_quality.STRATEGY_3351,data_quality.STRATEGY_3473 logfile=part1.log

从源库ftp导出文件到目标数据库

目标数据库重新导入这些表:

impdp system/****** dumpfile=part.dmp directory=dmp_dir logfile=imp_part1.log

。。。。。。

Processing object type TABLE_EXPORT/TABLE/TABLE

. . imported "DATA_QUALITY"."STRATEGY_3346" 56.15 MB 402254 rows

. . imported "DATA_QUALITY"."STRATEGY_6947" 2.149 GB 12473509 rows

. . imported "DATA_QUALITY"."STRATEGY_3351" 130.3 MB 2600527 rows

. . imported "DATA_QUALITY"."STRATEGY_3473" 658.6 MB 5669782 rows

。。。。。。

Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 15:51:40