Re: How to delete a database?

A database is composed of control files, data files, log files, shared memory and background processes. To drop the database you need to remove these objects.

The background processes and shared memory segment are removed every time the database successfully shuts down.

After the shutdown is performed then delete the files that make up the database and it is dropped. This will depend on your operating environment as to how easy this is and what level of access you'll need. You may want to get a list of files from dba_data_files and v$logfile before attempting to drop the database.

Bill Filion, Compuware, Inc.

Ku Kam Ming <kmku_at_hkusua.hku.hk> wrote in article <57m40n$5ej2_at_hkusud.hku.hk>...
>
> as title! No drop database statment!!
>
> Thanks,
> --
> **********************************************************************
> Kam-ming Ku (kmku) Big-5:[ÅUÀA©ú] GB: ~{9K=uCw~}
> *********************************************************************
>
>
>
Received on Sun Dec 01 1996 - 00:00:00 CST