-
ORA-01410 invalid ROWID
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?
-
re :
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.
ramya
-
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
John
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|