DataPump Import Terminates With Errors ORA-39083 ORA-29357 ORA-39126 ORA-6502 LPX-216 (Doc ID 1499141.1)

Last updated on AUGUST 01, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 12-Jun-2014***

Symptoms

While attempting to perform a DataPump import, the following errors were reported:

Import: Release 11.2.0.3.0 - Production on Thu Oct 11 13:03:43 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
Starting "SYSTEM"."SYS_IMPORT_FULL_01":  system/******** NETWORK_LINK=micr10gdb FULL=Y
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 4.225 GB
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [PROCACT_SYSTEM]
ORA-06502: PL/SQL: numeric or value error
LPX-00216: invalid character 0 (0x0)
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
00000003FB56EC98     20462  package body SYS.KUPW$WORKER
00000003FB56EC98      9028  package body SYS.KUPW$WORKER
00000003FB56EC98     16665  package body SYS.KUPW$WORKER
00000003FB56EC98      7885  package body SYS.KUPW$WORKER
00000003FB56EC98     10810  package body SYS.KUPW$WORKER
00000003FB56EC98      2728  package body SYS.KUPW$WORKER
00000003FB56EC98      9697  package body SYS.KUPW$WORKER
00000003FB56EC98      1775  package body SYS.KUPW$WORKER
00000003F99C1568         2  anonymous block
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOOK_FOR_OBJECT [PROCACT_SYSTEM]
SELECT process_order, duplicate, completion_time, in_progress FROM "SYSTEM"."SYS_IMPORT_FULL_01" WHERE  partition_name IS NULL AND subpartition_name IS NULL AND object_type = :1 AND object_schema IS NULL AND :2 IS NULL AND object_name IS NULL AND :3 IS NULL AND object_long_name IS NULL AND :4 IS NULL AND base_object_type IS NULL AND :5 IS NULL AND base_object_schema IS NULL AND :6 IS NULL AND base_object_name IS NULL AND :7 IS NULL AND grantor = :8
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 9007
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
00000003FB56EC98     20462  package body SYS.KUPW$WORKER
00000003FB56EC98      9028  package body SYS.KUPW$WORKER
00000003FB56EC98     14640  package body SYS.KUPW$WORKER
00000003FB56EC98     12485  package body SYS.KUPW$WORKER
00000003FB56EC98      7370  package body SYS.KUPW$WORKER
00000003FB56EC98     10810  package body SYS.KUPW$WORKER
00000003FB56EC98      2728  package body SYS.KUPW$WORKER
00000003FB56EC98      9697  package body SYS.KUPW$WORKER
00000003FB56EC98      1775  package body SYS.KUPW$WORKER
00000003F99C1568         2  anonymous block
Job "SYSTEM"."SYS_IMPORT_FULL_01" stopped due to fatal error at 13:10:20

Cause

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 hundreds of Community platforms