Database Software

Hallo,

I have a table with about 120000 records. In the column flaeche I have the geometry stored. Now I wanted to create the index by:

create index geb_fl_sidx on geb_tab(fl) indextype is mdsys.spatial_index;

But I get this message.

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: [mdrcrwrmem]
ORA-13234: failed to access R-tree-index table [GEBAEUDE_FLAECHE_SIDX_rt$:LOB
Write failure]
ORA-29400: data cartridge error
ORA-01653: unable to extend table SPATIAL2.MDRT_BEDC$ by 128 in tablespace
SPATIAL2
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10
ORA-06512: at line 1

I modified the statement with:

create index geb_fl_sidx on geb_tab(fl) indextype is mdsys.spatial_index parameters('sdo_max_memory=25000000');

or with:

UPDATE SDO_INDEX_METADATA SET SDO_RTREE_NUM_NODES=200000 WHERE SDO_INDEX_OWNER='SPATIAL2' AND SDO_INDEX_NAME='GEBAEUDE_FLAECHE_SIDX';

1 row updated.

SQL> select sdo_index_name,sdo_index_owner,sdo_rtree_num_nodes from sdo_index_metadata where sdo_index_name='GEBAEUDE_FLAECHE_SIDX';

SDO_INDEX_NAME SDO_INDEX_OWNER
-------------------------------- --------------------------------
SDO_RTREE_NUM_NODES
-------------------
GEBAEUDE_FLAECHE_SIDX SPATIAL2
200000

ERROR at line 1:
ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-29400: data cartridge error
ORA-01653: unable to extend table SPATIAL2.MDRT_BEE4$ by 128 in tablespace
SPATIAL2
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: [mdrcrwrmem]
ORA-13234: failed to access R-tree-index table [GEBAEUDE_FLAECHE_SIDX_rt$:LOB
Write failure]
ORA-29400: data cartridge error
ORA-01653: unable to extend table SPATIAL2.MDRT_BEE4$ by 128 in tablespace
SPATIAL2
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 261
ORA-06512: at line 1

I read that I could maybe use some other parameters? Is this useful?

I also used:CREATE INDEX GEBAEUDE_FLAECHE_SIDX ON GEBAEUDE_TAB(FLAECHE) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARAMETERS('SDO_MAX_MEMORY=25000000 SDO_RTR_OVERRIDE=0');

Has anybody a hint to overcome this?

Thanks Tig
I use a 10.1.0.3 database on suse linux enterprise server 9.