Re: Recovering from a corrupt DBF file

From: Chris Drew <cdrew_at_maine.rr.com>
Date: Sun, 5 Nov 2000 10:52:34 -0500
Message-ID: <zkfN5.6396$z96.125296@newsr1.maine.rr.com>

I believe that you must do this in mount mode. So, bring the database up in mount state and issue a alter database datafile <filename> offline drop; Not sure of the syntax, but I've had to do this with a production system before.. Good thing it was only an index tablespace!! Even better if it was a rollback... Have fun.

"Ron" <ron_at_yippy.yappy> wrote in message news:MPG.14543e02a3f1f1eb9896b2_at_news.alt.net...
> In article <8sdmjv$bu7$1_at_bob.news.rcn.net>, steven.long_at_erols.com says...
> > offline drop
> >
>
> Uh, thanks for that richly detailed, well written idea, and thank you for
> spending so much of your valuable time composing it. You are truly a
> master Oracle Database Administrator, and I humbly bow to acknowledge
> your amazing technical skill and articulate writing style.
>
> Now does anybody besides Steve have any suggestions for my problem?
> (Refer to my original post.)
Received on Sun Nov 05 2000 - 09:52:34 CST