在一次使用数据泵导出/导入工具(expdp/impdp),进行数据库数据迁移时,执行impdp命令时,发生了ora-600的错误,导致了部分表导入失败.经查,表的定义信息被导入,表的记录数为0.查询了metalink的相关文件,只找到关于导出时使用了压缩导致的问题,本例中导出是没有使用压缩的,所以不属于这种情况。
本例中导出是使用的文件分割,即在expdp命令中使用了filesize=10g的参数。
导出的语句和错误如下:
$impdp system/*** dumpfile=full_20110301_%U.dmp directory=imp_dir logfile=imp01.log
[@more@]。。。。。。
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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/32980/viewspace-1046725/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/32980/viewspace-1046725/