|Oracle® Database Administrator's Guide
11g Release 2 (11.2)
Part Number E17120-11
|PDF · Mobi · ePub|
Dropping a database involves removing its datafiles, redo log files, control files, and initialization parameter files.
Dropping a database deletes all data in the database.
To drop a database:
Submit the following statement:
To use the
DATABASE statement successfully, the database must be mounted in exclusive and restricted mode.
DATABASE statement has no effect on archived log files, nor does it have any effect on copies or backups of the database. It is best to use RMAN to delete such files. If the database is on raw disks, the actual raw disk special files are not deleted.
If you used the Database Configuration Assistant to create your database, you can use that tool to delete (drop) your database and remove the files.