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: howto drop a corrupt database ?

Re: howto drop a corrupt database ?

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Sun, 09 Nov 2003 20:22:18 GMT
Message-ID: <_lxrb.6753$hB5.877@nwrdny02.gnilink.net>

"DJ" <nospamplease_at_goaway.com> wrote in message news:Afxrb.1355$Tc2.9439_at_newsfep4-glfd.server.ntli.net...
>

--snip-
> >
> > It's kind of sad, with all the advanced features, Oracle failed to provide
> a
> > "drop database" command until now.
> >
> >
>
> im kind ain two minds about that. i could imagine a situation where someone
> does drop database and everything goes and they didnt mean to
> whereas havign to physically delete files is a clear intent of wanting to
> get rid of it.
>
> But thrn again, if I do wanna remove a database, i dont like having to faff
> around deleting every single file associated with it
>
>

It is said that 10g will provide a drop database command. Though I'd believe that the datafiles need to be OMF for oracle to clean up the datafiles also.

Anurag Received on Sun Nov 09 2003 - 14:22:18 CST

Original text of this message

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