ORA-29858: error occurred in the execution of ODCIINDEXALTER routine

[AntonGonak]

Hi, when I trying to rebuild the index with the following syntax:

alter index A13_IX1 rebuild;

The below generates the following errors:

ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-20084: No ST_GRIDS supplied in PARAMETERS clause
ORA-06512: на  "SDE.SPX_UTIL", line 702
ORA-06512: на  "SDE.ST_DOMAIN_METHODS", line 917
ORA-06512: на  "SDE.ST_DOMAIN_METHODS", line 1811

[VinceAngelo]

Domain indexes are slightly different birds.  I don't think ALTER INDEX ... REBUILD works on
SDO_GEOMETRY either.   I generally just DROP INDEX and CREATE INDEX with appropriate
parameters (or use 'sdelayer -o load_only_io ... ; sdelayer -o normal_io ...').

- V

[AntonGonak]

Where can I find the appropriate parameters for the index?

[AntonGonak]

I'm trying to do it, but nothing:

select index_name,parameters from user_indexes where index_name = 'A13_IX1' and domidx_opstatus = 'FAILED';

INDEX_NAME PARAMETERS
1A13_IX1

select * from SDE.st_geometry_index where index_name = 'A13_IX1';

OWNER TABLE_NAME COLUMN_NAME INDEX_ID GRID.GRID1 GRID.GRID2 GRID.GRID3 SRID   ***

What about the default parameters? Can I create an index with some default parameters?

[VinceAngelo]

The ArcGIS documentation covers the proper syntax for creating an ST_GEOMETRY index.
You'd want to research Oracle documentation to clean up an invalid index.

- V