Re: ORA-01410: invalid ROWID on Oracle 10gR2
as per bug 4052655, closed as not a bug, this is expected behavior (and parallel query in conjunction with an online index rebuild is not supported, as per documentation).
Colin 't Hart <firstname.lastname@example.org> wrote:
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
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
64bit Linux), so it's still possible on a newer version than 220.127.116.11
that Jonathan mentioned.
Sucker-punch spam with award-winning protection.
Try the free Yahoo! Mail Beta.