My Oracle Support Banner

ORA-01403: no data found With Large Value for Data Pump PARALLEL Parameter (Doc ID 2602871.1)

Last updated on JULY 20, 2024

Applies to:

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


When importing data from an 11g database into using Data Pump, a high value of the PARALLEL parameter consistently caused the session to fail as follows:

26-SEP-19 12:07:52.771: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE:"USER"."TABLE"]
ORA-01403: no data found
26-SEP-19 12:07:52.771: ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11259
26-SEP-19 12:07:52.771: ----- PL/SQL Call Stack -----
 object line object
 handle number name
0xba9f33588 27116 package body SYS.KUPW$WORKER
0xba9f33588 11286 package body SYS.KUPW$WORKER
0xba9f33588 21860 package body SYS.KUPW$WORKER
0xba9f33588 6007 package body SYS.KUPW$WORKER
0xba9f33588 12194 package body SYS.KUPW$WORKER
0xba9f33588 2081 package body SYS.KUPW$WORKER
0xba9f35bb8 2 anonymous block
26-SEP-19 12:07:52.771: l_valid: -3 - Not Loading DBA with type JOB




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.