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