RE: ORA-08102: index key not found, obj# 124885, file 48, block 55492
- From: Mohammad Rafiq <rafiq9857@xxxxxxxxxxx>
- To: "mohamed.houri@xxxxxxxxx" <mohamed.houri@xxxxxxxxx>, oracle list <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 13 Jun 2013 21:30:27 -0400
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@xxxxxxxxx
> To: oracle-l@xxxxxxxxxxxxx
>
> 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
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
