Internal Error In Spatial Index: [Mdidxrbd] importing index hz_locations_n15 (Doc ID 361112.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version 9.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 07-Nov-2012***

Symptoms

Importing a 9.2.0.5 DMP file into a new 9.2.0.5 DB gives error on Spatial index:

IMP-00017: following statement failed with ORACLE error 29855: "CREATE INDEX "HZ_LOCATIONS_N15" ON "HZ_LOCATIONS" ("GEOMETRY" ) INDEXTYPE " "IS "MDSYS"."SPATIAL_INDEX" PARAMETERS ('rebuild_index=HZ_LOCATIONS_N15_RT$ " "sdo_indx_dims=2 sdo_rtr_pctfree=10 tablespace=APPS_TS_TX_IDX')" IMP-00003: ORACLE error 29855 encountered ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-13249: internal error in Spatial index: [mdidxrbd] ORA-13209: internal error while reading SDO_INDEX_METADATA table ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 7 ORA-06512: at line 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