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?
Received on Mon Nov 10 2003 - 10:07:36 CST
