impdp 匯入資料導致ora-600,arguments: [klaprs_11]錯誤

在一次使用資料泵匯出/匯入工具(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