ORA-39125: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS while calling


author:skate
time:2007/12/28

我在执行impdp的时候

[oracle@new-host-2 ~]$ impdp system/rnwoxn table_exists_action=replace directory=DATA_PUMP_DIR dumpfile=movo_new.dmp schemas=movo_new remap_schema =movo_new:movo_new

...
...
...

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-00230: invalid character 52 (U+0034) found in a Name or Nmtoken

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6235

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x26472998     14916  package body SYS.KUPW$WORKER
0x26472998      6300  package body SYS.KUPW$WORKER
0x26472998     12279  package body SYS.KUPW$WORKER
0x26472998      3279  package body SYS.KUPW$WORKER
0x26472998      6889  package body SYS.KUPW$WORKER
0x26472998      1262  package body SYS.KUPW$WORKER
0x29965178         2  anonymous block

Job "SYSTEM"."SYS_IMPORT_SCHEMA_09" stopped due to fatal error at 11:47:32


经查证,原来是oracle10g的impdp的bug

在网上看见一个朋友的文章

在metalink查到这个:

书签 转到末尾

文档 ID:  注释:272874.1
主题:  Export DataPump: ORA-39125 Fatal Error in Worker while Calling DMSYS.DBMS_DM_MODEL_EXP.SCHEMA_CALLOUT
类型:  PROBLEM
状态:  PUBLISHED
 内容类型:  TEXT/X-HTML
创建日期:  17-MAY-2004
上次修订日期:  02-JUL-2004
 


The information in this article applies to:
Enterprise Manager for RDBMS - Version: 10.1.0.0 to 10.2.0.0
Oracle Server - Enterprise Edition - Version: 10.1.0.0 to 10.2.0.0
Oracle Server - Personal Edition - Version: 10.1.0.0 to 10.2.0.0
Oracle Server - Standard Edition - Version: 10.1.0.0 to 10.2.0.0
This problem can occur on any platform.

Errors
ORA-04063
ORA-06508
ORA-06512
ORA-31642
ORA-39125

而我现在用的是:

SQL> select * from v$version
  2  ;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production


而我在用 oracle 10.2.0.3.0和 oracle 10.2.0.2.0 都没有这问题,这个就是
10.2.0.1.0的bug,

修复bug  待续...

参考文章:

 http://orchidllh.itpub.net/post/4020/24082

 

评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值