| Srimayee |
Posted: Apr 21, 2008 05:53:40 AM |
Total Post: 7
Joined: Dec, 2005
|
Hi All,
I have a procedure which is executed on a daily basis by means of scheduled Unix jobs.
The procedure is pretty simple and has only a few update statements on a single table. However, it was only yesterday that I received an error ORA-01410: invalid ROWID when executing it.
Can anybody please explain the cause of this error?
Thanks in advance,
Srimayee.
|
|
|
 Murtuja |
| Posted: Apr 21, 2008 06:29:28 AM |  |
|
Total Post: 857
Joined: Jan, 2006
|
Does any index got corrupted ?
You can verify it by this query.
select * from dba_indexes where status<>'VALID'
You need to rebuild those indexes.
|
|
|
|
|
| Srimayee |
| Posted: Apr 21, 2008 07:06:57 AM | |
|
Total Post: 7
Joined: Dec, 2005
|
Thanks for your feedback. I do not find any index that is not valid. I just tried executing the procedure again and this time it went off successfully.
However, I'm clueless as to what could have happenned then.
Can anybody please suggest.
Thanks,
Srimayee.
|
|
|
|
|
| GOPU |
| Posted: Apr 21, 2008 07:36:38 AM | |
|
Total Post: 333
Joined: Apr, 2008
|
HI,
ROWIDS are
physical addresses -- the data got put in in different places after the truncate then it
did after an insert.
In fact, the DELETE/INSERT could equally easily throw the invalid rowid error as well.
ROWIDS are physical addresses and only exist for the life of a row. They can be reused
by some new row later.
and there may be some chances...it may occur...
chances of index getting corrupted.
Regards
Gopu
|
|
|
|
|
| Gitesh |
| Posted: Apr 22, 2008 01:41:55 AM | |
|
Total Post: 322
Joined: May, 2005
|
Hi,
It can happen due to another session is truncating table or deleting rows.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
