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.
[Edited by sankalp on 10-15-2002 at 11:21 AM]
Click Here to Expand Forum to Full Width