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]
This error is due to incorrect Oracle database installation. Specifically, Oracle Spatial was not installed properly (actually, the Spatial library is not linked into the oracle executable).
Problem can be solved as follows -
The database should be shutdown when doing this.
Login as unix user 'oracle'.
$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk sdo_on
or $ make -f ins_rdbms.mk sdo_on install
Oracle needs to be relinked with the spatial option turned on. In order to execute any of the internal spatial procedures, the Oracle executables will need to be linked with the spatial option turned on, see above syntax.