Re: Tracing invalid rowid ora-01410

  • From: "Anand Rao" <panandrao@xxxxxxxxx>
  • To: jonathan@xxxxxxxxxxxxxxxxxx
  • Date: Wed, 2 Aug 2006 17:07:14 +0530

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.


Jonathan Lewis

The Co-operative Oracle Users' FAQ

Cost Based Oracle: Fundamentals

----- 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 on AIX. > > This may not be applicable to our environment. >


Other related posts: