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> select name, open_mode from v$database;

--------- --------------------

SQL> drop database;

Database dropped.

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

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

Leave a Reply

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