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!

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
4,023 views