ORA-13209 Internal Error While Reading SDO_INDEX_METADATA Table While Creating Spatial Index (Doc ID 839424.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 10.2.0.4.0 and later
Information in this document applies to any platform.
***Checked for relevance on 15-Nov-2013***


Symptoms

Attempting to rebuild a spatial index gives the following errors:

create index ind_sp_admin_districts on mdt_admin_districts(geometry)
indextype is mdsys.spatial_index;

ORA-29855: Error occurred in the execution of ODCINDEXCREATE routine
ORA-13249: Internal error in Spatial index (
ORA-13209: Internal error while reading SDO_INDEX_METADATA table.
ORA-29400: data cartridge error
ORA-00904: "SDO_RTREE_ENT_XPND". Invalid Identifier
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_101", LINE 10

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