Spatial Index Creation Fails with ORA-13375 (Doc ID 865189.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version 9.2.0.8 and later
Information in this document applies to any platform.
This problem can occur on any platform.
***Checked for relevance on 26-Apr-2013***

Symptoms

Trying to create a spatial index and getting errors-

SQL> CREATE INDEX INSYNC.PIPE_SEGMENT_SP_ROUTE ON INSYNC.PIPE_SEGMENT
(ROUTE) INDEXTYPE IS MDSYS.SPATIAL_INDEX
PARAMETERS ('LAYER_GTYPE=POLYGON TABLESPACE=SPATIAL_INDEX_M');
CREATE INDEX INSYNC.PIPE_SEGMENT_SP_ROUTE ON INSYNC.PIPE_SEGMENT (ROUTE)
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: Error in Spatial index: index build failed
ORA-13249: Error in spatial index: [mdrcrtxfergm]
ORA-13249: Error in spatial index: [mdpridxtxfergm]
ORA-13200: internal error [ROWID:AAAGU4AAKAAAAUyAAA] in spatial indexing.
ORA-13206: internal error [] while creating the spatial index
ORA-13375: The layer is of type [] while geometry inserted has type []
ORA-06512: at "MDSYS.SDO_INDEX

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