My Oracle Support Banner

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 AUGUST 29, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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=<DIRECTORY_NAME> FULL=Y CONTENT=ALL PARALLEL=10 DUMPFILE=<DUMP_NAME>%U.dmp LOGFILE=<LOG_NAME>.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:"<SCHEMA_NAME>"."<TABLE_NAME>"]
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:"<SCHEMA_NAME>"."<TABLE_NAME>"]
ORA-06532: Subscript outside of limit

 

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
References


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