Hi,
I am trying to create a spatial index on data that contains point, line and rectangle geometries.

Each time I have run the create script, I get the following :

CREATE INDEX stabsame10_idx ON stabsame10(shape) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARAMETERS ('tablespace=treeidx2 initial=100M next =50M')
*
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-13236: internal error in R-tree processing: [failed to cluster in memory]
ORA-13249: Internal error in Spatial index: [mdrcrclmem]
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 7
ORA-06512: at line 1

However, when I check the status of the index in user_indexes :

SQL> select status, domidx_status, domidx_opstatus from user_indexes where INDEX_NAME = 'STABSAME10_IDX';

STATUS DOMIDX_STATUS DOMIDX
-------- ------------- ------
VALID VALID FAILED

Can anyone please tell me what I am doing wrong.

By the way, the table contains 1 million rows. And.... there is enough free space in the tablespace, there is enough space in the rollback segment, and I have set sort_area_size to 200 million. Also - I have system privilages.

Sankalp


[Edited by sankalp on 10-15-2002 at 11:21 AM]