Most probably this is due to index corruption:
To solve this:
analyze table schema.tablename validate structure cascade;
ERROR at line 1:
ORA-01499: table/index cross reference failure - see trace file
You need to drop this index and re create it.
go to the trace file and find the index object id the drop it and recreate it.
To solve this:
analyze table schema.tablename validate structure cascade;
ERROR at line 1:
ORA-01499: table/index cross reference failure - see trace file
You need to drop this index and re create it.
go to the trace file and find the index object id the drop it and recreate it.
No comments:
Post a Comment