How to Drop database in Oracle 10g and above

In order to drop database in 10g and above versions, it can be done in simple 3 easy steps:

1. Shutdown the database

SQL> shutdown immediate;

2. Startup in restricted mode

SQL> startup restrict mount;

3. Drop database

SQL> drop database;

Note: Please note that the above command does not clear off the archive log files. You will have to delete them maually.