Drop database in Oraclein10g
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
Requirements
•database must be closed,
•exclusively mounted,
•restricted
startup mount exclusive restrict;
drop database;
exit