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: to
This problem can occur on any platform.


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

Connected to: Oracle Database 10g Enterprise Edition Release - 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';




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

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.