Transportable Tablespace Import Failed with Imp-00058: Oracle Error 3113 (Doc ID 759558.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

Import of a transportable tablespace (TTS) export file,  failed with ORA-3113 when importing the AP_CHECKS_ALL table.   A patch for unpublished Bug 5072211 "OERI:kkdxce1 during transport tablespace IMPORT of table with CLOB and UNUSED column" had already been applied.

. . importing table                "AP_CHECKS_ALL" 
IMP-00058: ORACLE error 3113 encountered 
ORA-03113 : end-of-file on communication channel 
IMP-00000: Import terminated unsuccessfully

The tracefile showed this error:

Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x0, PC: [0x194191c, kkdxUpdateColInfo()+320]
*** 2008-09-25 22:11:58.629
ksedmp: internal or fatal error
ORA-07445 : exception encountered: core dump [kkdxUpdateColInfo()+320] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
Current SQL statement for this session:
BEGIN SYS.DBMS_PLUGTSP.PATCHTABLEMETADATA (:1, :2, :3, :4, :5); END; 

The call stack trace contained the following:

L_mutex_unlock_15 kkdxUpdateColInfo kkdxPatchTableColNumbers kcpptmd  spefcmpa 
spefmccallstd pextproc peftrusted psdexsp rpiswu2  psdextp pefccal pefcal pevm_FCAL pfrinstr_FCAL pfrrun_no_tool pfrrun  plsql_run peicnt kkxexe  opiexe
kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real main  libc_start_main start

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