DataPump Import (IMPDP) Fails With Errors ORA-39126 ORA-1403 No Data Found (Doc ID 729346.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 10-Feb-2015***

Symptoms

DataPump import (IMPDP) fails with the following errors:

Import: Release 10.2.0.3.0 - 64bit Production on Friday, 18 April, 2008 9:30:51

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning and Data Mining options
Master table "SCOTT"."NOMADM_TIPOS_ACCION_IMP" successfully loaded/unloaded
Starting "SCOTT"."NOMADM_TIPOS_ACCION_IMP": scott/******** JOB_NAME=NOMADM_TIPOS_ACCION_IMP TABLES=NOMADM.M4T_TIPOS_ACCION REMAP_SCHEMA=NOMADM:NOMADMPRU REMAP_TABLESPACE=NOMADM:NOMADMPRU DUMPFILE=NOMADM.M4T_TIPOS_ACCION.dmp LOGFILE=NOMADM.M4T_TIPOS_ACCION-IMP.log
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE:"NOMADMPRU"."M4T_TIPOS_ACCION"]
ORA-01403: no data found

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6266

----- PL/SQL Call Stack -----
object line object
handle number name
c0000000da9e5770 14916 package body SYS.KUPW$WORKER
c0000000da9e5770 6293 package body SYS.KUPW$WORKER
c0000000da9e5770 12280 package body SYS.KUPW$WORKER
c0000000da9e5770 3278 package body SYS.KUPW$WORKER
c0000000da9e5770 6882 package body SYS.KUPW$WORKER
c0000000da9e5770 1259 package body SYS.KUPW$WORKER
c0000000da9cdf78 2 anonymous block

Job "SCOTT"."NOMADM_TIPOS_ACCION_IMP" stopped due to fatal error at 09:30:58

Changes

SET ESCAPE ON has been added on the GLOGIN.SQL script.

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