My Oracle Support Banner

ORA-39126 ORA-24002 Encountered During DataPump Import (IMPDP) (Doc ID 2613217.1)

Last updated on APRIL 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

When processing TRANSPORTABLE_EXPORT/TABLE, impdp may raise the following errors:

...
Processing object type TRANSPORTABLE_EXPORT/TABLE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE:"<schema>"."AQ$_<table_name>"]
ORA-24002: QUEUE_TABLE <schema>.AQ$_<table_name> does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9715
----- PL/SQL Call Stack -----
object line object
handle number name
0x289cbfb60 21979 package body SYS.KUPW$WORKER
0x289cbfb60 9742 package body SYS.KUPW$WORKER
0x289cbfb60 17950 package body SYS.KUPW$WORKER
0x289cbfb60 4058 package body SYS.KUPW$WORKER
0x289cbfb60 10450 package body SYS.KUPW$WORKER
0x289cbfb60 1824 package body SYS.KUPW$WORKER
0x28bc45ea0 2 anonymous block
Job "SYS"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error

Changes

none

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.