ORA-01499: table/index cross reference failure - see trace file
I have logged the below error frequentry in alert log file and i found the trace file while running the delete statment against dms_audt table.
Errors in file e:\oracle\admin\s146pw01\udump\s146pw01_ora_5092.trc:
delete from dms_audt where o_acttime < TO_DATE('2010-03-12 15:24:44','yyyy-mm-dd hh24:mi:ss') and o_objtype between 10000 and 20000.
Two indexes are running in this table , i rebuild the index after a hour the error reproduced.
I did analyze the table it says"ORA-01499: table/index cross reference failure - see trace file"
Does it mean we have to drop two index and recreate again? Kindly suggest.