Spatial Index Error With ORA-13249 [mdidxrbd] in Oracle 19.20 (Doc ID 2981959.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

create table t1 (
 id integer,
 geometry sdo_geometry);
 
 insert into user_sdo_geom_metadata values ('T1','GEOMETRY',
 sdo_dim_array(
  sdo_dim_element('x',400000, 750000, .0005),
  sdo_dim_element('y',500000, 1000000, .0005)
  ),262152);  
 
  create index t1_spidx on t1 (geometry) indextype is mdsys.spatial_index ;
 
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10
29855. 00000 - "error occurred in the execution of ODCIINDEXCREATE routine"
*Cause: Failed to successfully execute the ODCIIndexCreate routine.
*Action: Check to see if the routine has been coded correctly.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.