My Oracle Support Banner

Impdp terminates by ORA-07445 [kdblcbo] when importing compressed Table (Doc ID 780570.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7
This problem can occur on any platform.

Symptoms

impdp system/manager dumpfile=tc.dmp parfile=tc.par

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_FULL_06" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_06": system/******** DIRECTORY=DATA_PUMP_DIR dumpfile=exp.dmp
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.
Job "SYSTEM"."SYS_IMPORT_FULL_06" stopped due to fatal error at 14:23:59
ORA-39014: One or more workers have prematurely exited.

Errors in file /u01/app/oracle/admin/TC/bdump/tc_dw01_4583456.trc:
ORA-07445: exception encountered: core dump [kdblcbo+02c0] [SIGSEGV] ...

ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kdblcbo+02c0] [SIGSEGV] [Address
not mapped to object] [0xFFFFFFFFFFFFFFFE] [] []
Current SQL statement for this session:
INSERT /*+ SYS_DL_CURSOR */ INTO RELATIONAL("TC1"."TAB1") <== Affected table
...

Call Stack Trace
~~~~~~~~~~~~~~~~
kdblcbo kdblai klaai klald kpodpls opiodr kpoodr upirtrc
...

SQL> select compression from dba_tables where owner='TC1' and table_name='TAB1';

COMPRESS
--------
ENABLED

 

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
  Cause
  Solution
      PATCH
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.