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.
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.
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment