Wow! great reply Jonathan :)
Possible cause:
ORA-01410 can be the result of one session working through a long running query that depends on an index that gets rebuilt by another session
The index "moves", but the first session is still using the previous version of the index (read consistency across DDL). If the space freed by the rebuild is then re-used, the first session is likely to crash with a 1410.
Regards
Jonathan Lewis http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis
The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
----- Original Message ----- > Date: Fri, 28 Jul 2006 09:44:03 -0700 (PDT) > From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx> > Subject: Re: Tracing invalid rowid ora-01410 > > We are on 10.2.0.2 on AIX. > > This may not be applicable to our environment. >
-- //www.freelists.org/webpage/oracle-l