FreeLists / oracle-l / Re: Tracing invalid rowid ora-01410

["Anand Rao" <panandrao@xxxxxxxxx>]

Wow! great reply Jonathan :)

On 02/08/06, Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx> wrote:
> 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.
> >
>
> --
> http://www.freelists.org/webpage/oracle-l