Drop Database in Oracle 10g

     It has become easier to drop a database from Oracle 10g. Use the DROP DATABASE command to drop the database. It removes the datafiles,redologs, controlfiles and init parameter files.

$ sqlplus / as sysdba

SQL> Shutdown immediate;

SQL> Startup Mount Exclusive Restrict;

SQL> Drop Database;