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: astalavista <nobody_at_nowhere.com>
Date: Sun, 7 Jan 2007 09:41:44 +0100
Message-ID: <45a0b242$0$285$426a34cc@news.free.fr>


Thanks ...

If I do:
> alter database datafile '...' offline ;

                                        offline immediate ?
                                          offline drop ?
( what option to use ? the datafile is really gone ?) I can open the database ?
Drop the tablespace ?
Then I can generate script to rebuild indexes ( with TOAD ) Re-create the tablespace
Rebuild the indexes

Thanks for your help ... Received on Sun Jan 07 2007 - 02:41:44 CST

Original text of this message

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