Datapump Export Fails With ORA-00600 kdlrci_get_inline_data On Table With Securefile Lob Compression (Doc ID 1370927.1)

Last updated on JUNE 15, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms


A datapump export of a table containing a Spatial column that utilizes SECUREFILE LOB COMPRESSION fails with:

ORA-31693: Table data object "TEST"."FOO" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-00600: internal error code, arguments: [kdlrci_get_inline_data], [1658], [64], [210], [], [], [], [], [], [], [], []


Simplified test case:

create user test identified by test;

grant connect, resource, dba to test;

conn test/test

CREATE TABLE foo(comid NUMBER, shape SDO_GEOMETRY)
VARRAY SHAPE.SDO_ELEM_INFO STORE AS SECUREFILE LOB (COMPRESS HIGH)
VARRAY SHAPE.SDO_ORDINATES STORE AS SECUREFILE LOB (COMPRESS HIGH);

--- THROW A POINT INTO IT

INSERT INTO foo (comid,shape) VALUES (1,SDO_GEOMETRY(2001,8265,NULL,SDO_ELEM_INFO_ARRAY(1,1,1),SDO_ORDINATE_ARRAY(-110.92709057003,35.2720031499154)));
COMMIT;

--- EXPORT USING DATAPUMP, THROWS 00600 ERROR


drop directory DIR;
create directory DIR as '/tmp';
grant read on directory DIR to public;

host expdp test/test DIRECTORY=DIR DUMPFILE=test.dmp LOGFILE=my_logdir


It also reproduces without SDO_GEOMETRY, only an object varray with compression

drop table t1;
create or replace type my_varray AS VARRAY (1048576) of NUMBER;
/
CREATE TYPE obj_varray AS OBJECT (
obj_col my_varray);
/

CREATE TABLE t1 (a obj_varray)
VARRAY a.obj_col STORE AS SECUREFILE LOB (COMPRESS LOW);

INSERT INTO t1 VALUES (obj_varray(my_varray(1)));
COMMIT;
!rm test.dmp
host expdp test/test DIRECTORY=DIR DUMPFILE=test.dmp LOGFILE=my_logdir



-- error
ORA-31693: Table data object "TEST"."T1" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-00600: internal error code, arguments: [kdlrci_get_inline_data], [1658], [64], [210], [], [], [], [], [], [], [], []

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