How to Use Drop Database Command in Oracle 11gR2?



The Eucharistic Miracles of the World
Post Update on 23-Nov-2013 with screenshot.
Dropping a database will remove all corresponding datafile, redo log files, control files and init parameter files. Obviously it removes all the data in the database. The database must be mounted in exclusive and restricted mode.
Drop database command will not do any effect on archived log files and backups of the database. For this purpose you can use RMAN to delete such file. Drop database command will not delete the files on RAW disks.
If you created your database with DBCA, you can use the same DBCA tool to drop the database.


$export ORACLE_SID=DEV12

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup mount exclusive restrict
ORACLE instance started.

Total System Global Area 282352256 bytes
Fixed Size                  2132856 bytes
Variable Size            1644174848 bytes
Database Buffers         1140850688 bytes
Redo Buffers               36388864 bytes
Database mounted.

SQL> drop database;

Database dropped.
Note: If your database is running on windows you have to remove the registry entries manually.


Website Stats


Post a Comment


Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2) Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer