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.
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
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.