Transportable Tablespace Import With Spatial Indexes Fails With ORA-39083 ORA-1410 ORA-942 (Doc ID 1529243.1)

Last updated on FEBRUARY 14, 2013

Applies to:

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

Symptoms

Transportable tablespace import (impdp) fails with errors such as the following:

     "...
     Processing object type TRANSPORTABLE_EXPORT/DOMAIN_INDEX/INDEX
     ORA-39083: Object type INDEX failed to create with error:
     ORA-01410: invalid ROWID
     Failing sql is:
     BEGIN
     declare schema_name varchar2(200); begin
     select sys_context('userenv', 'CURRENT_SCHEMA') into schema_name from dual;
     mdsys.sdo_idx_tts_index_initialization(schema_name, 'RTREE','0','0','64','-1','MDRT_6C91B
     $','<value>','1','<value>','"GEOM"','0','0','3','54','DEFAULT','MDRS_6C91B
     $',HEXTORAW(''), '<value>',
     '','','','','','2','POINT','10','H2011025','1','','4','TRUE','VALID','MDRT_6C91
     ORA-39083: Object type INDEX failed to create with error:
     ORA-00942: table or view does not exist
     Failing sql is:
     BEGIN
     declare schema_name varchar2(200); begin
     select sys_context('userenv', 'CURRENT_SCHEMA') into schema_name from dual;
     mdsys.sdo_idx_tts_index_initialization(schema_name, 'RTREE','0','0','64','-1','MDRT_F32BB
     $','<value>','1','<value>','"SHAPE"','4','4846','3','54','AADzK8AAgAAAAi9
        AAF','MDRS_f32BB$',HEXTORAW(''), '<value>',
     '','','','','','2','POINT','10','S2005365','1'
     ..."

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