Re: How to delete a database?

Ku Kam Ming <kmku_at_hkusua.hku.hk> wrote:

>
>as title! No drop database statment!!
>
>Thanks,
>--
>**********************************************************************
>Kam-ming Ku (kmku) Big-5:[ÅUÀA©ú] GB: ~{9K=uCw~}
>*********************************************************************
>
Hello Kam-ming Ku!
You're right, there is no drop database command! The Oracle7 Server Administrator's Guide Release 7.2 says:

To drop a database remove its datafiles,redo log files, and all other associated files(control files,parameter files,archived log files). To view the names of the files query the dictionary views V$DBFILE and V$LOGFILE. That is what I'm usually doing myself. You could of cource write a program/script that query the views and deletes the files for you.

Regds Rune Received on Fri Nov 29 1996 - 00:00:00 CET