My Oracle Support Banner

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

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
Symptoms
Cause
Solution


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.