Drop a database

Please follow below steps to drop a database :

SQL>  shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount exclusive restrict;
ORACLE instance started.

Total System Global Area  780140544 bytes
Fixed Size                  2929256 bytes
Variable Size             578817432 bytes
Database Buffers          192937984 bytes
Redo Buffers                5455872 bytes
Database mounted.


SQL> drop database;

Database dropped.

Using RMAN you can also drop as below:


RMAN> DROP DATABASE INCLUDING BACKUPS;

database name is "TEST" and DBID is 19077478

Do you really want to drop all backups and the database (enter YES or NO)? yes

There are other syntax with drop database , you can try those also.