RE: ORA-08102: index key not found, obj# 124885, file 48, block 55492

From: Mohammad Rafiq <rafiq9857_at_hotmail.com>
Date: Thu, 13 Jun 2013 21:30:27 -0400
Message-ID: <BAY177-W28B18D1A5EBDBB06473D53A1800_at_phx.gbl>

If you have btree/bitmap index with multiple keys and rebuild id with parallel options 4, it may produce that error. It was quite a while back when I encountered this issue. The issue observed when users started using table data next day.  

The only option to drop such indexes with multiple keys and recreate them.  

Regards
Rafiq  

> Date: Thu, 13 Jun 2013 19:17:07 +0200
> Subject: ORA-08102: index key not found, obj# 124885, file 48, block 55492
> From: mohamed.houri_at_gmail.com
> To: oracle-l_at_freelists.org
>
> Dears,
> I have been trying to simulate the ora-08102 index key not found error but
> without success. Can someone show a model to reproduce this error?
>
> Thanks in advance
>
> --
> Bien Respectueusement
> Mohamed Houri
> www.hourim.wordpress.com
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
                                               

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 14 2013 - 03:30:27 CEST