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

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