Drop Database

Oracle provide a method to drop a database with a single statement starting from Oracle 10g.  This method uses DROP DATABASE command in RMAN.

 

The target database must be mounted in EXCLUSIVE mode with RESTRICTED SESSION enabled.

 

DROP DATABASE INCLUDING BACKUPS;

 

$ sqlplus "/ as sysdba"

SQL> shutdown immediate;

SQL> startup mount exclusive

alter system enable restricted session

 
SQL> exit

$ rman target /
RMAN> drop database including backups;



Advertisements

One response to this post.

  1. Dear Friend,

    In Oracle 10g we can also drop database using SQL PLUS with command “drop database ” as sysdba.

    Thanks and regards,
    Gitesh
    http://www.dbametrix.com

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: