How to Use Drop Database Command in Oracle 11gR2?

advertisements

_____________________________________________________________________________________________________________________

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.

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.

_____________________________________________________________________________________________________________________

A visitor from Delaware viewed 'enq: TX - index contention Wait Event , Cause, Rel' 24 mins ago
A visitor from Bourgogne viewed 'SQL scripts for index performance analysis in Orac' 1 hr 16 mins ago
A visitor from Bengaluru viewed 'SQL Loader bad file vs Discard File: Difference an' 1 hr 18 mins ago
A visitor from Mumbai viewed 'SQL Query to Find Out Oracle Session Details for a' 1 hr 47 mins ago
A visitor from Zapopan viewed 'Fix DGMGRL Error: ORA-16698: LOG_ARCHIVE_DEST_n pa' 2 hrs 8 mins ago

0 comments:

Post a Comment

Labels

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)
 

acehints.com Copyright 2011-25 All Rights Reserved | Site Map | Contact | Disclaimer