How to Use Drop Database Command in Oracle 11gR2?

advertisements

_____________________________________________________________________________________________________________________

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.

Example.

$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