ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
originally posted by CamilaGomez (but as a Document)
Hi,
I´m try to rebuild one index but i have the next error:
SQL> ALTER INDEX LOCATIONS_NDX4 REBUILD;
ALTER INDEX LOCATIONS_NDX4 REBUILD
*
ERROR at line 1:
ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-20000: Oracle Text error:
DRG-10561: index LOCATIONS_NDX4 is not valid for requested operation
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 552
This is in oracle database version 10.2.0.3, Someone know i have to do? because i need to rebuild the index.
Thank's
Camila
Hi,
I´m try to rebuild one index but i have the next error:
SQL> ALTER INDEX LOCATIONS_NDX4 REBUILD;
ALTER INDEX LOCATIONS_NDX4 REBUILD
*
ERROR at line 1:
ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-20000: Oracle Text error:
DRG-10561: index LOCATIONS_NDX4 is not valid for requested operation
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 552
This is in oracle database version 10.2.0.3, Someone know i have to do? because i need to rebuild the index.
Thank's
Camila
0