My Oracle Support Banner

Error ORA-39078 Received During DataPump Parallel Import (Doc ID 790775.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Server - Enterprise Edition - Version: to - Release: 10.2 to 11.1
Information in this document applies to any platform.


Following errors are encountered when performing DataPump parallel import:

ORA-39029: worker 3 with process name "DW03" prematurely terminated
ORA-31671: Worker process DW03 had an unhandled exception.
ORA-39078: unable to dequeue message for agent KUPC$A_1_20090313003200 from queue "KUPC$C_1_20090313002622"
ORA-06512: at "SYS.KUPW$WORKER", line 1397
ORA-06512: at line 2

Import command line:

#> impdp system/password schemas=SCOTT parallel=4 DIRECTORY=DUMP_DIR
LOGFILE=IMP.log DUMPFILE=exp_01.dmp,exp_02.dmp,exp_03.dmp,exp_04.dmp


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

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

In this Document

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