Re: ORA-01499 even after drop recreating ALL indexes (minus PK, UK)

From: mohamed houri <mohamed.houri_at_gmail.com>
Date: Wed, 30 Jan 2013 09:30:47 +0100
Message-ID: <CAJu8R6j-b4HWZ-SN+rms+-M2f_KgbR-ec2hxuRY=AMgtrLiUvQ_at_mail.gmail.com>

Strange situation
I have been confronted to not exactly the same error but in the same area  (ora-08102-index-key-not-foun)

http://hourim.wordpress.com/2012/02/06/how-to-solve-ora-08102-index-key-not-found/

where a "alter table t1 move" solved my problem

You may find interesting comments(made by Jason Bucata) in the above blog article

Best regards
Mohamed Houri
www.hourim.wordpress.com

2013/1/29 <Christopher.Taylor2_at_parallon.net>

> Looks like a BOGUS error after crosschecking a full table scan with an
> index scan - no rowid differences between the 2 sets of results.
>
> Chris
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Christopher.Taylor2_at_parallon.net
> Sent: Tuesday, January 29, 2013 2:36 PM
> To: oracle-l_at_freelists.org
> Subject: ORA-01499 even after drop recreating ALL indexes (minus PK, UK)
>
> Ok, so I have to actually chuckle about this since it's got me stumped.
> I have a theory but need to verify.
>
> I have a missing ROWID in an INDEX so I dropped it and recreated it.
>
> Run analyze table, validate structure - boom. Invalid rowid again.
>
> Drop all indexes other than PK and UK and reanalyze table.
>
> Analyze comes back clean with PK and UK indexes in place. Ok.
>
> Recreate the dropped indexes.
>
> Analyze table.
>
> Bam. Missing Rowid.
>
> Weird thing is, after the index is recreated it has the same
> data_block_address_file and data_block_address_block entries.
>
> (that is, each time the index is recreated, the offending block is "row
> not found in index tsn: 16 rdba: 0x05cb87ac")
>
> The RDBA and TSN is always the same. That strikes me as odd, but perhaps
> a block on the data storage device is bad? But I find it odd that the same
> index would hit the same block every time.
>
>
>
> Chris Taylor
> Oracle DBA
> Parallon IT&S
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Bien Respectueusement
Mohamed Houri


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

Received on Wed Jan 30 2013 - 09:30:47 CET