DataPump Import (IMPDP) With DISABLE_ARCHIVE_LOGGING:Y Reports ORA-00942 [TABLE_DATA:"SYS"."KU$_EXPORT_USER_MAP"] Or 'ORA-06532: Subscript outside of limit'

(Doc ID 2014162.1)

Last updated on OCTOBER 13, 2017

Applies to:

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

Symptoms

While loading the data through DataPump import (impdp) with TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y, using the command:

> impdp system DIRECTORY=cssdp_dump FULL=Y CONTENT=ALL JOB_NAME=imp_csencdp PARALLEL=10 DUMPFILE=cssdp_dump:exp_cssd%U.dmp LOGFILE=cssdp_dump:imp_csencdp_metrics.log METRICS=YES STATUS=600 TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y

the following errors are reported:

Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CHANGE_ARCHIVE_LOGGING [TABLE_DATA:"SYS"."KU$_EXPORT_USER_MAP"]
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11259

 
- or -

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_MD_TRANSFORMS [TABLE_DATA:"SYSADM"."PS_PROJ_RES_TAO1"]
ORA-06532: Subscript outside of limit

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

----- PL/SQL Call Stack -----
object line object
handle number name
0x53b6a3548 27116 package body SYS.KUPW$WORKER
0x53b6a3548 11286 package body SYS.KUPW$WORKER
0x53b6a3548 17909 package body SYS.KUPW$WORKER
0x53b6a3548 17557 package body SYS.KUPW$WORKER
0x53b6a3548 7282 package body SYS.KUPW$WORKER
0x53b6a3548 5377 package body SYS.KUPW$WORKER
0x53b6a3548 12176 package body SYS.KUPW$WORKER
0x53b6a3548 2081 package body SYS.KUPW$WORKER
0x2cf601900 2 anonymous block

v_tea: TRUNCATE
stmt = SELECT flags, xml_clob FROM "SYSTEM"."SYS_IMPORT_FULL_01" WHERE process_order = :1 AND duplicate = 0
In INIT_MD_ARCHIVE_LOGGING for RESTORE_ARCHIVE_LOGGING
In procedure LOAD_MD_TRANSFORMS
DBMS_METADATA.OPENW
DBMS_METADATA.OPENW
In SET_REMAP_TRANSFORM with index 3 and object type
l_valid: -1 - Not Loading RESTORE_ARCHIVE_LOGGING with type NULL
DBMS_METADATA.SET_PARSE_ITEM
In procedure DETERMINE_FATAL_ERROR with ORA-06532: Subscript outside of limit
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_MD_TRANSFORMS [TABLE_DATA:"SYSADM"."PS_RPLN_REQ_TAO8"]
ORA-06532: Subscript outside of limit

 

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