How To Drop Database In Oracle 11 using SQLPLUS i.e. without Using DBCA

Written by Choma

May 20, 2018

To blow away one of your newly created databases, instead of using the DBCA, try it manually in sqlplus.

Requirements

  • database must be closed,
  • exclusively mounted,
  • restricted

1- Start The database

sqlplus / as sysdba
SQL> startup
ORACLE instance started.
Total System Global Area 3340451840 bytes
Fixed Size 2217952 bytes
Variable Size 1828718624 bytes
Database Buffers 1493172224 bytes
Redo Buffers 16343040 bytes
Database mounted.
Database opened.

2- Shutdown the database 

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

3- Start in Exclusive mode 

SQL> startup mount exclusive restrict
ORACLE instance started.
Total System Global Area 3340451840 bytes
Fixed Size 2217952 bytes
Variable Size 1828718624 bytes
Database Buffers 1493172224 bytes
Redo Buffers 16343040 bytes
Database mounted.

4- Drop the database

SQL> drop database;
Database dropped.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>

Summary
shutdown abort;
startup mount exclusive restrict; 
drop database;
exit

You May Also Like…

Annotation example

This is an example of annotation, hover the highlighted "annotation" word to see it in action!If you find the plugin...

0 Comments

Submit a Comment

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