We are currently using Oracle 11g version 11.2.0.4.0. This was recently upgraded from 11.2.0.2
I have a table that contains SDO line geometries. I recently discovered that our users could no longer use this table as it is intended. It is used for creating collision diagrams. The error shown within the app was:
ORA-29875: failed in the execution of the ODCIINDEXINSERT routine ORA-13033: Invalid data in the SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY object ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 720 ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 225 ORA-01403: no data found
So I dropped the spatial index and tried to recreate it, but when I do I get the following error:
ORA-29855: error uccurred 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:AABy2bAAOAAA|WEAAA] in spatial indexing.
ORA-13206: internal error[] while creating the spatial index
ORA-13033: Invalid data in the SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY object
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", LINE10
I have created a new table and tried copying the data into it and then create the index, but that fails with the same error. I have done this also for one record and this fails too, however, if I create the geometry like this:
SDO_GEOMETRY(
2002, -- two-dimensional line
28355,
NULL,
SDO_ELEM_INFO_ARRAY(1,2,1),
SDO_ORDINATE_ARRAY(527499.571,5249811.468, 527501.246,5249812.983, 527502.316,5249811.801))
Then it will happily create a spatial index.
When comparing the two geometries, in sql developer using georaptor, I can not see a difference.
I can create a spatial index on other tables with no issues.
Can anyone shed some light on this?