Manually dropping an Oracle Database

Export the Oracle SID before dropping it, making sure you are working on that required database.

Follow the steps as below:

SQL> shutdown abort

ORACLE instance shut down.

SQL> startup mount exclusive restrict;

ORACLE instance started.

Total System Global Area  535662592 bytes

Fixed Size                  1334380 bytes

Variable Size             167773076 bytes

Database Buffers          360710144 bytes

Redo Buffers                5844992 bytes

Database mounted.

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options