Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Corrupt block
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