DBA Hub

📋Steps in this guide1/2

Drop Database - Bright DBA

How to Drop the Database Manually Note: DROP DATABASE command will delete the database. The database must be mounted exclusive and not open, and started in RESTRICT mode.  DO NOT RUN ON PRODUCTION SQL> startup restrict mount; ORACLE instance started. Total System Global Area 835104768 bytes Fixed Size 2232960 bytes Variable Size 666897792 bytes Database … Continue reading Drop Database →

oracle clusteringintermediate
by OracleDba
12 views
1

Overview

Note: DROP DATABASE command will delete the database. The database must be mounted exclusive and not open, and started in RESTRICT mode.  DO NOT RUN ON PRODUCTION startup restrict mount; MOUNTED drop database;

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
SQL>
startup restrict mount;
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size                  2232960 bytes
Variable Size             666897792 bytes
Database Buffers          163577856 bytes
Redo Buffers                2396160 bytes
Database mounted.
SQL>
SQL> select name, open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
TEST
MOUNTED
SQL>
drop database;
Database dropped.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
2

Section 2

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!