Impdp Fails with ORA-39126 ORA-911 During Create Function (文档 ID 1254246.1)

Impdp Fails with ORA-39126 ORA-911 During Create Function (文档 ID 1254246.1)转到底部

---

修改时间:2010-10-26类型:PROBLEM

In this Document
  Symptoms
  Cause
  Solution
  References

---

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Symptoms

Impdp Fails with ORA-39126 ORA-911 during create function.

import.log shows:

Errors encountered
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [FUNCTION:"SCHEMA"."FUNCTION_NAME"]
CREATE FUNCTION "SCHEMA"."FUNCTION_NAME" RETURN current_version_t PIPELINED IS
finishedStatus integer := version_control.TranslateStatus('Finished');

and

Errors encountered
ORA-00911: invalid character
Errors encountered
ORA-06512: at "SYS.KUPW$WORKER", line 5168
Errors encountered
ORA-06512: at "SYS.KUPW$WORKER", line 12639
Errors encountered
ORA-00911: invalid character
Errors encountered
ORA-00911: invalid character
Errors encountered
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
Errors encountered
ORA-06512: at "SYS.KUPW$WORKER", line 6279
----- PL/SQL Call Stack -----
object      line  object
handle    number  name
000007FFC819A280     14916  package body SYS.KUPW$WORKER
000007FFC819A280      6300  package body SYS.KUPW$WORKER
000007FFC819A280     12279  package body SYS.KUPW$WORKER
000007FFC819A280      3279  package body SYS.KUPW$WORKER
000007FFC819A280      6889  package body SYS.KUPW$WORKER
000007FFC819A280      1262  package body SYS.KUPW$WORKER
000007FFBB9C4338         2  anonymous block

Job "NAME\ORACLE"."IMP_100902154255" stopped due to fatal error at 15:44:52
Disconnecting ...

Cause

This is caused by Bug 6785067
The bug shows the same error messages ORA-39126 and  ORA-911 in KUPW$WORKER.PUT_DDLS.
Development has suspected that Bug 5345978 is the underlying problem.

Solution

Bug 5345978 is fixed in version 11 and patchset 10.2.0.4 plus patch bundle 25 or higher.

Possible Workaround:

Please check, if there is possibly any special character in the user name,
who is running the impdp utility.
For example if scripts are run as an externally identified user. In Windows such user name is always <domain>\<user> and hence always consists of special character "\".

References

BUG:6785067 - IMPDP FAILS WITH ORA-39126 KUPW$WORKER.PUT_DDLS AND ORA-911