Frequently asked question
Code:
SQL> CREATE INDEX sewers_shp_idx ON sewers (shape)
2 INDEXTYPE IS sde.st_spatial_index
3 PARAMETERS ('st_grids=100 st_srid=999');
CREATE INDEX sewers_shp_idx ON sewers (shape)
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20083: Parameter ST_SRID 999 does not exist in ST_SPATIAL_REFERENCES table.
ORA-06512: at "SDE.SPX_UTIL", line 712
ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 941
Code:
SQL> SELECT index_name, domidx_opstatus
2 FROM user_indexes
3 WHERE index_name = 'SEWERS_SHP_IDX';
INDEX_NAME DOMIDX
------------------------------ ------
SEWERS_SHP_IDX FAILED
Code:
SQL> DROP INDEX sewers_shp_idx;
Index dropped.
SQL> CREATE INDEX sewers_shp_idx ON sewers (shape)
2 INDEXTYPE IS sde.st_spatial_index
3 PARAMETERS ('st_grids=100 st_srid=9');
Index created.
Get help from ArcGIS experts
Download the Esri Support App