DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-01410 invalid ROWID

  1. #1
    Join Date
    Jan 2004
    Posts
    10

    Unhappy 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?

  2. #2
    Join Date
    Sep 2003
    Location
    india
    Posts
    23

    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

  3. #3
    Join Date
    Jun 2005
    Location
    London, UK
    Posts
    159
    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?

  4. #4
    Join Date
    May 2005
    Location
    Toronto Canada
    Posts
    57
    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
  •  


Click Here to Expand Forum to Full Width