topic ORA-29858: error occurred in the execution of ODCIINDEXALTER routine in Data Management Questions

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

AntonGonak — Wed, 12 Sep 2012 04:19:54 GMT

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

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

VinceAngelo — Wed, 12 Sep 2012 10:03:45 GMT

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

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

AntonGonak — Wed, 12 Sep 2012 10:28:18 GMT

Where can I find the appropriate parameters for the index?

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

AntonGonak — Wed, 12 Sep 2012 10:45:54 GMT

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?

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

VinceAngelo — Wed, 12 Sep 2012 11:50:41 GMT

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