Pages

Thursday 8 March 2012

How to Drop Database in Oracle 10g and onwards...


#> sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.3.0 Production on Thu Mar 8 23:22:42 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
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> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup restrict mount;
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size                  2228784 bytes
Variable Size             402656720 bytes
Database Buffers         1191182336 bytes
Redo Buffers                7344128 bytes
Database 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 comments:

  1. how to drop a database..using dbca command...in otherwords i want to delete a database by selecting the option (delete database) in dbca list of option..when i try to delete a database using this option i am getting ora-01031-Insufficient privileges...

    ReplyDelete
  2. With which user you have logged into the server? User must be same as software owner.

    ReplyDelete