Re: IOT table index got corrupted with no backup of table

From: joel garry <>
Date: Thu, 10 Sep 2009 09:30:04 -0700 (PDT)
Message-ID: <>

On Sep 9, 10:58 pm, "" <> wrote:
> Hi All,
> IOT table in our database env. got corrupted in last december. Now
> some people want to use old archive data from this table. But there is
> corruption in its index (Physical - 17, Logical - 180, no. of
> datafiles - 60, size of index - 111GB). We don't have this old backup,
> so we can't recover it from that.
> We have already tested  DBMS_REPAIR, BLOCKRECOVER - RMAN, exp/imp but
> nothing it working...
> Can any one please give suggest.
> is there any way we can recover uncorrupted data from this table ?
> Thanks

See metalink Note: 61685.1

Figure out the rowid's of the corrupt blocks and skip them.


-- is bogus.
Give a man a fish you feed him for a day.
Teach a man to fish and you've fed him for life.
Mass-market fish and you have a series of ecological disasters:
Received on Thu Sep 10 2009 - 11:30:04 CDT

Original text of this message