Database Software

Hi,

I am getting this error when I am creating spatial index on geometry.

I suspect I have some problem with some rows of my geometry data. I have identified and fixed these problems so far. but I still getting error on spatial index creation.

-emptry Gtype in some rows
-wrong Gtype in some rows

Complete Error.

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: mdidxrbd
ORA-13249: iError in Spatial Index: index build fialed
ORA-13200: Internal error RowID:AAANZE/AAFAAALFaAAP..... 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", line 10

I have line data for this table and below is the sample data.

GEOMETRY(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES)
--------------------------------------------------------------------------------
SDO_GEOMETRY(2002, 2958, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(
598520.994, 4837106.63, 598462.359, 4837164.63))

SDO_GEOMETRY(2002, 2958, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(
599229.43, 4837127.13, 599089.675, 4837264.62))

SDO_GEOMETRY(2002, 2958, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(
599280.002, 4837024.46, 599295.689, 4837048.09, 599296.21, 4837055.13, 599294.64
5, 4837062.43, 599229.43, 4837127.13))

SDO_GEOMETRY(2002, 2958, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(

GEOMETRY(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES)
--------------------------------------------------------------------------------
599089.675, 4837264.62, 599028.567, 4837324.34))

SDO_GEOMETRY(2002, 2958, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(
595925.144, 4839146.42, 596002.765, 4839128.11, 596007.989, 4839126.85, 596013.5
22, 4839123.09, 596056.926, 4839089.74, 596100.769, 4839065.62, 596106.694, 4839
063.81, 596110.438, 4839064.27, 596115.548, 4839066.47, 596181.122, 4839135.22,
596183.623, 4839140.59, 596183.706, 4839145.03, 596183.319, 4839148.15, 596181.1
78, 4839152.64, 596174.794, 4839163.26, 596165.136, 4839174.75, 596143.191, 4839
194.57))


Please also note that I have correct dimension in "sdo user geom meta data" table and in my table.

Any help is greatly appreciated.

Rose