Oracle 10g: How to drop Oracle database

Dropping database from sqlplus

1. Shutdown the database

SQL> shutdown immediate;

2. Mount exclusive and put in restricted mode

SQL> startup nomount;

SQL> alter database mount exclusive;

SQL> alter system enable restricted session;

3. Drop database

SQL> drop database;