Home » RDBMS Server » Server Administration » ORA0410: invalid ROWID
ORA0410: invalid ROWID [message #191845] Fri, 08 September 2006 06:23 Go to next message
gajini
Messages: 262
Registered: January 2006
Senior Member
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,
Gajini.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,
Gajini.

Report message to a moderator

Re: ORA0410: invalid ROWID [message #191860 is a reply to message #191845] Fri, 08 September 2006 07:13 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Quote:

If I reexecute the same procedure,will it execute successfully or
again it throws ORA0410: invalid ROWID


Seriously? You've been posting here for a while. SURELY you realize that the best way to answer that question is to try it!! Embarassed

Report message to a moderator

Re: ORA0410: invalid ROWID [message #192000 is a reply to message #191845] Sat, 09 September 2006 14:00 Go to previous message
oigor
Messages: 8
Registered: September 2006
Location: Athens, GREECE
Junior Member
Hi,

If you have a long running procedure that involves a cursor that will rely upon the index you rebuild, and if you run it and, while the proc is running, you rebuild the index, then the message "invalid ROWID" is absolutely normal.

The message will not appear next time you execute the procedure, if you don't rebuild your index again during the execution Smile

-------

Igor Obradovic

Report message to a moderator

Previous Topic: can't install 8i in Windows Server2003
Next Topic: ora 4030 while using logminer
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:34:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.