IMPDP Fails With ORA-31693/ORA-14400 On Certain Partitioned Tables (Doc ID 1235434.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 11.2.0.2.0 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

Using IMPDP the following errors were encountered:

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.LOAD_DATA while calling KUPD$DATA.START_JOB [TABLE_DATA:"XX"."XXXX":"ODSSC
P15112009"]
ORA-24795: Illegal ROLLBACK attempt made
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 10804
ORA-00600: internal error code, arguments: [kupdls_rdData_01], [ORA-26095: unprocessed stream data exists]


<Note 832315.1> was used to try and solve and on impdp ... content=data_only errors then changed to:

. . imported "XX"."XXXX":"ODSSCP25112009" 13.61 GB 79886661 rows
ORA-31693: Table data object "XX"."XXXX":"ODSSCP15112009" failed to load/unload and is being skipped due to error:
ORA-14400: inserted partition key does not map to any partition
. . imported "XX"."XXXX":"ODSSCP24112009" 13.13 GB 77152759 rows
ORA-31693: Table data object "XX"."XXXX":"ODSSCP16112009" failed to load/unload and is being skipped due to error:
ORA-14400: inserted partition key does not map to any partition
. . imported "XX"."XXXX":"ODSSCP23112009" 12.77 GB 74671253 rows

where XX is the schema and XXXX is the table name. These are edited to XX so that article does not contain customer information.

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