ORA-01410: invalid ROWID on Oracle 10gR2
Colin 't Hart
ORA-01410: invalid ROWID on Oracle 10gR2 -- Colin 't Hart 2007-01-25
Last night I encountered an ORA-01410: invalid ROWID during a long running query (5+ hours)
I Googled on ORA-01410 and saw this notehttp://www.freelists.org/archives/oracle-l/08-2006/msg00075.html
from Jonathan Lewis how this is possible if an index is rebuilt while the query is running -- which is probably what happened here: our nightly refresh process was started earlier than normal to rectify a data error and about 15mins alter
my query errored out with:
ORA-12801: error signaled in parallel query server P004, instance odork12.nuon.local:A01ORK02 (2)
ORA-01410: invalid ROWID
The interesting thing is that this happened on Oracle 10gR2 (64bit version of 10.2.0.2.0 on
64bit Linux), so it's still possible on a newer version than 220.127.116.11 that Jonathan mentioned.
with award-winning protection.
Try the free Yahoo! Mail Beta.