René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

drop database in Oracle

Since 10g, It is possible to drop a database in Oracle 10g with the new SQL statement drop database.
The command gets rid of datafiles online redo log files, controlfiles and spfile.
Shaikh Ismail sent me an example on how to use the command. Thank you very much! Here it is:
shutdown abort;
startup mount exclusive restrict; 
drop database;
exit

Requirements

  • database must be closed,
  • exclusively mounted,
  • restricted