Oracle10.2.0.3 impdp 匯入資料包 ORA-39125 in KUPW$WORKER.PUT_DDLS LPX-00007問題解決

Windows平臺上的10.2.0.3資料庫，當使用impdp命令向資料庫中匯入資料的時候報如下錯誤：

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS while calling DBMS_METADATA.CONVERT [TABLE:....] ORA-6502: PL/SQL: numeric or value error LPX-00007: unexpected end-of-file encountered ORA-6512: at "SYS.DBMS_SYS_ERROR", line 105 ORA-6512: at "SYS.KUPW$WORKER", line 6234 ----- PL/SQL Call Stack ----- object line object handle number name 0x25bd1d0c8 14916 package body SYS.KUPW$WORKER 0x25bd1d0c8 6293 package body SYS.KUPW$WORKER 0x25bd1d0c8 12280 package body SYS.KUPW$WORKER 0x25bd1d0c8 3278 package body SYS.KUPW$WORKER 0x25bd1d0c8 6882 package body SYS.KUPW$WORKER 0x25bd1d0c8 1259 package body SYS.KUPW$WORKER 0x25de5e9f0 2 anonymous block

經查詢這是oracle的一個bug（bug號為：5535956）

[@more@]下面是metalink上給出的問題描述：
This is Bug 6635956:

If DBMS_METADATA.GET_DDL fails with the following errors and audit$ column in tab$, view$, seq$, procedure$, dir$, user$, type_misc$, or library$ contains NULL characters, it's probably this bug.

ORA-6502: PL/SQL: numeric or value error LPX-00007: unexpected end-of-file encountered ORA-6512: at "SYS.UTL_XML", line 259 ORA-6512: at "SYS.DBMS_METADATA_INT", line 10269 ORA-6512: at "SYS.DBMS_METADATA_INT", line 10384 ORA-6512: at "SYS.DBMS_METADATA", line 2361 ORA-6512: at "SYS.DBMS_METADATA", line 3247 ORA-6512: at "SYS.DBMS_METADATA", line 4863 ORA-6512: at line 1

In the case of the datapump import, you would see the following errors.
Note that the object name in the error message does not always match the object whose audit$ column contains the NULL character.

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS while calling DBMS_METADATA.CONVERT [TABLE:"SH"."MV_CAPABILITIES_TABLE"] ORA-6502: PL/SQL: numeric or value error LPX-00007: unexpected end-of-file encountered ORA-6512: at "SYS.DBMS_SYS_ERROR", line 105 ORA-6512: at "SYS.KUPW$WORKER", line 6234 .----- PL/SQL Call Stack ----- object line object handle number name 0x2bc6c228 14916 package body SYS.KUPW$WORKER 0x2bc6c228 6293 package body SYS.KUPW$WORKER 0x2bc6c228 12280 package body SYS.KUPW$WORKER 0x2bc6c228 3278 package body SYS.KUPW$WORKER 0x2bc6c228 6882 package body SYS.KUPW$WORKER 0x2bc6c228 1259 package body SYS.KUPW$WORKER 0x2add8080 2 anonymous block

下面是metalink上給出的解決問題的方法

If on 10.2.0.3, apply Patch 6753556 which merges: Base Bugs: 6753556 6529662 5515882 4352110 6635956 There is also a generic platform patch available on 10.2.0.3 or 10.2.0.4 in Patch 6635956: Or use the following workaround: Replace NULL chars in audit$ column with '-' by issuing an appropriate NOAUDIT command, and re-enable auditing operations using AUDIT command if needed. Then, retrieve the metadata or perform the export/import

--end--