ORA-01410 invalid ROWID

[happy_jack]

Oracles,

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?

[rumcool]

hi,

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.

[WilliamR]

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?

[John Spencer]

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

John