Re: howto drop a corrupt database ?

"Ed Stevens" <nospam_at_noway.nohow> wrote in message news:jsdvqv05do7g29sltb2ipjilnhu8too9jt_at_4ax.com...
> On Sun, 09 Nov 2003 20:22:18 GMT, "Anurag Varma" <avdbi_at_hotmail.com>
> wrote:
>
> >
> >"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
> >
> Why would they have to be OMF? Oracle has always been able to create
> OS files (CREATE TABLESPACE . . .), so why couldn't it delete them?

Ed,

I don't know .. I don't have access to 10G.

So :) I'm in no position to debate about this.

Anurag Received on Mon Nov 10 2003 - 11:36:47 CST