My Oracle Support Banner

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 MARCH 12, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information 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:

DW01 started with pid=97, OS id=3060, wid=2, job SYSTEM.SYS_IMPORT_TABLE_02
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:

.....  kpodpbis <- kpodpp <- opiodr <- kpoodr <- upirtrc <- kpurcsc <- kpudpxp_ctxPrepare <- OCIDirPathPrepare <- kpxspiStreamModePos <- tInit <- kpxsOpen <- tInit <- qxxqOpen <- spefcpfa <- spefmccallstd <- pextproc <- pgmcetc_execute_tru <- sted_c <- pgmccc_call_c <- sted_c <- pciccc_call_c <- kkxmcexe <- kgmexcb <- kkxmswu <- kgmexwi <- kgmexec <- evapls <- evaopn2 <- qximeop_fbk <- qximeop <- qxxmeop <- qesxtGetTableInfo <- kxfrSourceMap <- kxfrialo <- kxfralo <- qerpx_rowsrc_start <- qerpxStart <- insExecSubQueryIni <- insExecStmtExecIniE <- ngine <- insexe <- ngine <- opiexe <- opiall0 <- opikpr <- opiodr <- rpidrus <- skgmstack <- rpiswu2 <- kprball <- kkxspdbswitch_cbk <- kkxsexr <- kkxsexe <- pevm_icd_call_commo <- pfrinstr_ICAL <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe <- kpoal8 <- opiodr <- kpoodr <- upirtrc <- kpurcsc <- kpuexec <- OCIStmtExecute <- kupprwp <- ksvrdp <- opirip <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main <- libc_start_main <- start .....

 

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.