My Oracle Support Banner

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

Last updated on MAY 18, 2021

Applies to:

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

Symptoms

When importing data from an 11g database into 12.1.0.2 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

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution


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