Re: ORA-8102, why?
Date: Wed, 16 Jan 2008 17:20:53 +0100
"Cristian Cudizio" <cristian.cudizio_at_yahoo.it> schreef in bericht
> On Jan 16, 3:11 pm, "shakespeare" <what..._at_xs4all.nl> wrote:
>> "Cristian Cudizio" <cristian.cudi..._at_yahoo.it> schreef in
>> > Hello,
>> > i've an Oracle database with RAC 2 node version 10.1.0.5 on Linux
>> > Suse SLES9 64 bit. Recently i've
>> > got an error ORA-8102 during the execution of a procedure that was
>> > deleting some records. So i have found that
>> > there are two records (the table has over 90 milions of records) for
>> > which there are no corresponding index entry on one of the indexes.
>> > I've read metalink notes 395006.1 and 1081343.6 and i can't understand
>> > how can it happen. The note 395006.1 say's about "lost write ore some
>> > similar OS issue" but how can be that there are no database block
>> > corruptions? The notes say also that dropping and recreating the index
>> > does not solve the issue. How can it be? is there anyone that can
>> > explain me that? Since the problem occurs only when i try to change
>> > the value of the indexed column for the two record or to delete the
>> > records i've choose to let things as are now, because exporting e re-
>> > importing the entire table woud be to expensive.
>> > Thanks,
>> > Cristian Cudizio
>> Are you using a function based index on this table?
> No, it is a normal b-tree index on one field of type DATE. there are
> other 5 indexes on other field and they are correct.
> Cristian Cudizio
I think you misunderstand note 395006.1: it does not say dropping and recreating the index won't help. It's a description of the symptom. You could drop and recreate the index and see if the error remains.
Shakespeare Received on Wed Jan 16 2008 - 10:20:53 CST