Re: howto drop a corrupt database ?

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
>

The drop database command is redundant as you already (in 8i) can delete a database using the database creation assistant.

--
Sybrand Bakker, Senior Oracle DBA