How To Drop A Database In Oracle | How To Drop Oracle Database Manually

Through this article, we will learn to drop a whole database in Oracle manually with commands.  We can also use the DBCA utility to drop a whole database but this is not in scope for today’s discussion.

Steps to follow for dropping a database

Please follow the below steps to drop a database successfully. 

Please set the environment for the database and shut it down using the below command.


$ sqlplus / as sysdba

SQL> shutdown immediate;


Then mount the database in exclusive restrict mode using the below command.

SQL> startup mount exclusive restrict

And then drop the database using the below command

SQL> drop database;


Now your database has been dropped successfully.

Leave a Comment

Your email address will not be published. Required fields are marked *