今天在使用impdp往生产库导入数据时报如下错误：
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS while calling DBMS_METADATA.CONVERT []
ORA-06502: PL/SQL: numeric or value error
LPX-00225: end-element tag "HIST_GRAM_LIST_ITEM" does not match start-element tag "EPVALUE"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6307
----- PL/SQL Call Stack -----
object line object
handle number name
7000006f6648c90 15032 package body SYS.KUPW$WORKER
7000006f6648c90 6372 package body SYS.KUPW$WORKER
7000006f6648c90 12391 package body SYS.KUPW$WORKER
7000006f6648c90 3346 package body SYS.KUPW$WORKER
7000006f6648c90 4032 package body SYS.KUPW$WORKER
7000006f6648c90 7014 package body SYS.KUPW$WORKER
7000006f6648c90 1314 package body SYS.KUPW$WORKER
70000077328ea98 2 anonymous block
Job "SYSTEM"."SYS_SQL_FILE_FULL_02" stopped due to fatal error at 11:57:58
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS while calling DBMS_METADATA.CONVERT []
ORA-06502: PL/SQL: numeric or value error
LPX-00225: end-element tag "HIST_GRAM_LIST_ITEM" does not match start-element tag "EPVALUE"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6307
----- PL/SQL Call Stack -----
object line object
handle number name
7000006f6648c90 15032 package body SYS.KUPW$WORKER
7000006f6648c90 6372 package body SYS.KUPW$WORKER
7000006f6648c90 12391 package body SYS.KUPW$WORKER
7000006f6648c90 3346 package body SYS.KUPW$WORKER
7000006f6648c90 4032 package body SYS.KUPW$WORKER
7000006f6648c90 7014 package body SYS.KUPW$WORKER
7000006f6648c90 1314 package body SYS.KUPW$WORKER
70000077328ea98 2 anonymous block
Job "SYSTEM"."SYS_SQL_FILE_FULL_02" stopped due to fatal error at 11:57:58
查询metalink的后发现这可能是10.2.0.4以前的一个Bug 8500616 : IMPDP FAILS WITH ORA-39125 LPX-00225 ERROR. ，后来在google上又发现很多类似的错误，唯一不同的是他们的错误中在DBMS_METADATA.CONVERT 中明确指明是[table_statistics]和统计信息相关的错误，于是我试着在导入时将统计信息给屏蔽，结果导入成功了再也没有报错，不足是导入数据后需手动收集统计信息。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/20801486/viewspace-745246/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
