Drop Database

How to Drop the Database Manually

Note: DROP DATABASE command will delete the database. The database must be mounted exclusive and not open, and started in RESTRICT mode.  DO NOT RUN ON PRODUCTION

SQL> startup restrict mount;
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size                  2232960 bytes
Variable Size             666897792 bytes
Database Buffers          163577856 bytes
Redo Buffers                2396160 bytes
Database mounted.
SQL>
SQL> select name, open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
TEST      MOUNTED

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. 

 

1 thought on “Drop Database

  1. HI Rajasekhar,

    Greetings of the day,

    Your site is useful for every DBA. Could you please explain how to install Database manually .

Leave a Reply

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