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;


-- OR --


srvctl stop db -d [SID]
srvctl remove database -d [SID]
dbca -silent -deleteDatabase -sourceDB [SID]