How to delete a database in Oracle 11 without using DBCA

1-The SID of the imported database, if not defined

Export Oracle_sid=database

2-Connect to the database with operating system authentication

[Email protected] ~]$ sqlplus/as sysdbasql*plus:release 11.2.0.1.0 Production on Mon Dec 1 17:38:02 2014Copyright (c) 1982, Oracle. All rights reserved. Connected to an idle instance.

3-Starting the DB instance

Sql> Startuporacle instance started.  Total System Global area 3340451840 bytesfixed size 2217952 bytesvariable size 1828718624 bytesdatabase buffers 1493172224 Bytesredo buffers 16343040 bytesdatabase mounted. Database opened.

4-Close the database

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

5-Start Exclusive mode

Sql> Startup Mount Exclusive Restrictoracle instance started.  Total System Global area 3340451840 bytesfixed size 2217952 bytesvariable size 1828718624 bytesdatabase buffers 1493172224 Bytesredo buffers 16343040 bytesdatabase mounted.

6-Deleting a database

Sql> Drop Database;<br>database dropped.  Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit productionwith The partitioning, OLAP, Data Mining and Real application testing options

Complete!

How to delete a database in Oracle 11 without using DBCA