ORA-29855 ORA-13249 [mdidxrbd] ORA-13249: SRID 8703 WKT does not exist in MDSYS.CS_SRS table

(Doc ID 2382513.1)

Last updated on APRIL 04, 2018

Applies to:

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

Symptoms

On : 12.2.0.1 version, Spatial Analysis Mining

cannot create index for a table

Tried to create index MAP_USER.MD_COUNTIESE_WGS84_SIDX Got errors
 CREATE INDEX MAP_USER.MD_COUNTIESE_WGS84_SIDX ON MAP_USER.MD_COUNTIES_WGS84 (GEOMETRY)
  INDEXTYPE IS MDSYS.SPATIAL_INDEX 2 ;
 CREATE INDEX MAP_USER.MD_COUNTIESE_WGS84_SIDX ON MAP_USER.MD_COUNTIES_WGS84 (GEOMETRY)
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: SRID 8703 WKT does not exist in MDSYS.CS_SRS table
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10

 

ERROR
-----------------------
ORA-29855, ORA-13249, ORA-13249, ORA-06512

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