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

Thread: ORA 0410: invalid ROWID

  1. #1
    Join Date
    May 2006
    Posts
    41

    ORA 0410: invalid ROWID

    Hi,

    I got this ORA0410: invalid ROWID,while executing a stored procedure,after
    started executing the procedure,I rebuilt the index associated with that procedure.

    Here is what i did & got,
    T1: exec procA
    T2: rebuild index
    T3: rebuild finishes
    T4: ORA0410: invalid ROWID


    Clear the follwing things to me,

    1. Whether i got ORA0410: invalid ROWID,due to index rebuild during procedure execution or is there any other reason?
    2. If I reexecute the same procedure,will it execute successfully or
    again it throws ORA0410: invalid ROWID.If the same error will be given
    again,then what are all the steps I've to follow before execting this
    procedure so that it'll be executed successfully.

    Thanks

  2. #2
    Join Date
    Sep 2005
    Posts
    278
    What your procedure actually does?

  3. #3
    Join Date
    May 2006
    Posts
    41
    This error is reported by developer,I don't know at procedure level,but from the info collected from them,I finally traced out this could be the reason for this error.

    The traced info is,
    T1: exec procA by developer
    T2: rebuild index by me
    T3: rebuild finishes
    T4: ORA0410: invalid ROWID

    Thanks

  4. #4
    Join Date
    Sep 2005
    Posts
    278
    I thinks its not the problem with rebuilding index.

    Something to do with the procedure, you can speak to your developers and know what exactly the procedure doing, you might find the reason.

  5. #5
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Can they reproduce this - obvioulsy whilst you are NOT rebuilding any indexes? If so, its their code.

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