Datapump Import fails with ORA-31693 ORA-29913 ORA-29400 ORA-00600 [kpodpbis failure2] ORA-06598 and ORA-06512 Errors
(Doc ID 2646670.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
1. Datapump Import fails with the following errors and there is no issue with the export:
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_TABLE_02" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TABLE_02": system/******** dumpfile=FULL_EXP_MAR02_01.dmp,FULL_EXP_MAR02_02.dmp,FULL_EXP_MAR02_03.dmp,FULL_EXP_MAR02_04.dmp tables=<schema>.<table name>,<schema>.<table name> logfile=<impdp log file name>.log parallel=4 table_exists_action=TRUNCATE directory=data_pump_dir_mig content=data_only
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "<schema>"."<table name>" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
ORA-00600: internal error code, arguments: [kpodpbis failure2], [6598], [ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "SYS.KUPD$DATA", line 4186
ORA-06512: at line 1
], [], [], [], [], [], [], [], [], []
ORA-31693: Table data object "<schema>"."<table name>" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
ORA-00600: internal error code, arguments: [kpodpbis failure2], [6598], [ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "SYS.KUPD$DATA", line 4186
ORA-06512: at line 1
], [], [], [], [], [], [], [], [], []
Job "SYSTEM"."SYS_IMPORT_TABLE_02" completed with 2 error(s) at Wed Mar 4 01:06:07 2020 elapsed 0 00:00:11
2. The alert log might have the following errors:
ORA-00600: internal error code, arguments: [kpodpbis failure2], [6598], [ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "SYS.KUPD$DATA", line 4186
ORA-06512: at line 1
], [], [], [], [], [], [], [], [], []
3. The failing functions and the call stack is similar to the following:
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 |