How to drop database

Simple Step-

In 10g onwards dropping a database is very easy. Earlier in order to drop a database it was required to manually
remove all the datafiles, control files,redo logfiles and init,password file etc but with oracle 10g dropping a database is a single command.

In order to drop the database start the database in restrict mode and bring it in mount state as shown:

1. Logging into db
sqlplus / as sysdba

2.SQL> shutdown immediate;
oracle database closed
oracle database dismounted
oracle instance shutdown

3.SQL> startup restrict mount;

4.SQL> drop database;

Database dropped

5.SQL> exit

Thus we will find all files are deleted.