Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Corrupt block

Re: Corrupt block

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 07 Jan 2007 05:51:18 +0100
Message-ID: <enojs2$a43$1@news6.zwoll1.ov.home.nl>


astalavista schreef:
> 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 ...
>
>

Drop the tablespace and datafile; open db; rebuild indexes from either an export (using the indexfile= option) or an application installation script.

About the only reason to separate indexes from tables.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Sat Jan 06 2007 - 22:51:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US