News

  1. Home
  2. All posts
All posts, Oracle by Team Ajara

How to drop Oracle database?

To drop Oracle database…

oracle@ORASRVR:/u00/app/oracle/ [ORCL] sqlplus “/as sysdba”


SQL*Plus: Release 11.2.0.4.0 Production on Fri Aug 12 17:38:21 2022

Connected to an idle instance.

 

SQL> startup mount restrict
ORACLE instance started.


Total System Global Area 3206836224 bytes
Fixed Size 2250648 bytes
Variable Size 754976872 bytes
Database Buffers 2432696320 bytes
Redo Buffers 16912384 bytes
Database mounted.

SQL> select name,open_mode,version,host_name from v$database,v$instance;



NAME OPEN_MODE VERSION
——————————————
HOST_NAME
———————
ORCL MOUNTED 11.2.0.4.0
ORASRVR

SQL> select created from v$database;

CREATED
————————–
2022-08-09 17:48:31

 

SQL> drop database;

Database dropped.

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

 

See Also: