My Oracle Support Banner

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

Last updated on MAY 13, 2021

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.1 to 11.1]
Information in this document applies to any platform.
This problem can occur on any platform.


impdp system/password 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 <ADR_base>/diag/product_type/product_id/instance_id>/bdump/<SID>_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

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