Re: Corrupt block

astalavista wrote:
> Hi,
>
> 8.1.7
> I had a corrupt block in a datafile in tablespace
> holding only indexes.
> The database cannot be opened ...
> What I have to do ?
>
> Thanks in advance ...

The DBMS_REPAIR built-in package has existed since 8.1.5.

Look over my page on this package in Morgan's Library at www.psoug.org.

Specific part of this package to consider using are:

DBMS_REPAIR.CHECK_OBJECT
DBMS_REPAIR.FIX_CORRUPT_BLOCKS
DBMS_REPAIR.ONLINE_INDEX_CLEAN
DBMS_REPAIR.SKIP_CORRUPT_BLOCKS

HTH

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org