ORA-01410 invalid ROWID
what kind of stuff causes invalid ROWID errors while retrieving records?
i mean i have this query which retrieves, say, 100,000 records and half-way into it while at the 25,000th record or something, it throws the error, "ORA-01410 invalid ROWID"
anyone has ideas?
chances of index getting corrupted.
run the explain plan on it to see what index it is using , then drop and recreate it or try to do an export...and just drop the index and recreate it.
Did another session delete the record? Or it's a partitioned table and someone updated the partition key, or it's an index-organized table and someone updated a primary key column?
Are you one of those who regularly rebuilds indexes?
T0 Query starts using index x as access path
T1 Issue ALTER INDEX x REBUILD
T2 Rebuild finishes
T3 Query tries to fetch another row INVALID ROWID