Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

12c Data Pump Import Fails With ORA-39126: Worker Unexpected Fatal Error In KUPW$WORKER

User_8KB49Aug 7 2019 — edited Aug 13 2019

Has anyone come across this error during an import. I found a bug with exports but not sure if its related to imports as well.

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=226287901367280&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&…

Here is the error I got in specifics:

. . imported
"SYSADM"."PTGRANTTBL"                         
0 KB       0 rows

. . imported
"SYSADM"."SQL_PROF_STGTAB"                    
0 KB       0 rows

ORA-39126: Worker unexpected fatal error in
KUPW$WORKER.CHANGE_ARCHIVE_LOGGING
[TABLE_DATA:"SYSADM"."PS_UC_R289_RPT_STG"]

ORA-00942: table or view does not exist

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPW$WORKER", line 11252

----- PL/SQL Call Stack -----

  object      line
object

  handle    number  name

0x2d40df628     27109  package body
SYS.KUPW$WORKER

0x2d40df628     11279  package body
SYS.KUPW$WORKER

0x2d40df628      7338  package
body SYS.KUPW$WORKER

0x2d40df628      5377  package
body SYS.KUPW$WORKER

0x2d40df628     12169  package body
SYS.KUPW$WORKER

0x2d40df628      2081  package
body SYS.KUPW$WORKER

0x2e5778e90       
2  anonymous block

In SET_DDL_TRANSFORM with index 3 and object type TABLE

DBMS_METADATA.SET_TRANSFORM_PARAM

DBMS_METADATA.SET_TRANSFORM_PARAM

ORA-39126: Worker unexpected fatal error in
KUPW$WORKER.CHANGE_ARCHIVE_LOGGING
[TABLE_DATA:"SYSADM"."PS_XX_ACA_AET"]

ORA-00942: table or view does not exist

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPW$WORKER", line 11252

----- PL/SQL Call Stack -----

  object      line
object

  handle    number  name

0x2d40df628     27109  package body
SYS.KUPW$WORKER

0x2d40df628     11279  package body
SYS.KUPW$WORKER

0x2d40df628      7338  package
body SYS.KUPW$WORKER

0x2d40df628      5377  package
body SYS.KUPW$WORKER

0x2d40df628     12169  package body
SYS.KUPW$WORKER

0x2d40df628      2081  package
body SYS.KUPW$WORKER

0x2e5778e90       
2  anonymous block

In SET_DDL_TRANSFORM with index 3 and object type TABLE

DBMS_METADATA.SET_TRANSFORM_PARAM

DBMS_METADATA.SET_TRANSFORM_PARAM

Job "SYS"."SYS_IMPORT_SCHEMA_02" stopped
due to fatal error at Mon Aug 5 12:53:31 2019 elapsed 0 02:18:23

==

syntax used :

nohup impdp \"/ as sysdba\"  schemas=xxxx parallel=8 directory=export
dumpfile=
xxx.dmp
logfile=xxx.log table_exists_action=skip transform=disable_archive_logging:y
exclude=statistics &

Comments

Post Details

Added on Aug 7 2019
6 comments
3,455 views