Re: howto drop a corrupt database ?

Anurag Varma wrote:

>"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
>
>

Well I do have 10g. And since I have no idea what OMF stands for that may well answer the question.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)