Oracle Text (MOSC)

MOSC Banner

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

edited Dec 27, 2010 3:34AM in Oracle Text (MOSC) 1 commentAnswered
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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center