ORA-01410: invalid ROWID on Oracle 10gR2

Hi,

Last night I encountered an ORA-01410: invalid ROWID during a long running query (5+ hours)
I Googled on ORA-01410 and saw this note
http://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 9.2.0.4 that Jonathan mentioned.

Cheers,

Colin







 
____________________________________________________________________________________
Expecting? Get great news right away with email Auto-Check. 
Try the Yahoo! Mail Beta.
http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html 

--
http://www.freelists.org/webpage/oracle-l