Might be interesting to figure out if uses the old index if the current index is marked unusable. On Wed, Aug 25, 2010 at 3:14 PM, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx>wrote: > I think it was already pretty much proven by Ilmar Kerm in an earlier > post: > > > > //www.freelists.org/post/oracle-l/Oracle-XE-Corruption,12 > > > > Regards, > > Brandon > > > > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Jared Still > > > > This would seem to validate the statement in the docs that 'REBUILD' does > > read the old index rather than table data. > > > > Someone care to test this? > > > > ------------------------------ > Privileged/Confidential Information may be contained in this message or > attachments hereto. Please advise immediately if you or your employer do not > consent to Internet email for messages of this kind. Opinions, conclusions > and other information in this message that do not relate to the official > business of this company shall be understood as neither given nor endorsed > by it. > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'