IMPDP Fails With ORA-31693/ORA-14400 On Certain Partitioned Tables
(Doc ID 1235434.1)
Last updated on FEBRUARY 23, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.3 to 11.2.0.2.0 [Release 10.2 to 11.2]Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
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:"<SCHEMA_NAME"."<TABLE_NAME>":"<PARTITION_NAME>"]
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]
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 "<SCHEMA_NAME>"."<TABLE_NAME1>":"<PARTITION_NAME1>" 13.61 GB 79886661 rows
ORA-31693: Table data object "<SCHEMA_NAME>"."<TABLE_NAME1>":"<PARTITION_NAME2>" failed to load/unload and is being skipped due to error:
ORA-14400: inserted partition key does not map to any partition
. . imported "<SCHEMA_NAME>"."<TABLE_NAME1>":"<PARTITION_NAME3>" 13.13 GB 77152759 rows
ORA-31693: Table data object "<SCHEMA_NAME>"."<TABLE_NAME1>":"<PARTITION_NAME3>" failed to load/unload and is being skipped due to error:
ORA-14400: inserted partition key does not map to any partition
. . imported "<SCHEMA_NAME>"."<TABLE_NAME1>":"<PARTITION_NAME4>" 12.77 GB 74671253 rows
ORA-31693: Table data object "<SCHEMA_NAME>"."<TABLE_NAME1>":"<PARTITION_NAME2>" failed to load/unload and is being skipped due to error:
ORA-14400: inserted partition key does not map to any partition
. . imported "<SCHEMA_NAME>"."<TABLE_NAME1>":"<PARTITION_NAME3>" 13.13 GB 77152759 rows
ORA-31693: Table data object "<SCHEMA_NAME>"."<TABLE_NAME1>":"<PARTITION_NAME3>" failed to load/unload and is being skipped due to error:
ORA-14400: inserted partition key does not map to any partition
. . imported "<SCHEMA_NAME>"."<TABLE_NAME1>":"<PARTITION_NAME4>" 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.
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 |