Drop Oracle Database Manually (not using DBCA)

1. set ORACLE_SID to your database that you want to drop

$ export ORACLE_SID=orcl

2. login to sqlplus using sysdba

$ sqlplus / as sysdba

3. mount the database

SQL> startup force mount;

4. Enable Restricted session;

SQL> alter system enable RESTRICTED session;

5. Drop the database

SQL> drop database;


2 responses to “Drop Oracle Database Manually (not using DBCA)”

  1. ida says :

    wih wih wih…
    bisa gitu ya? hahaha…
    laen x tak coba.. :p
    thx for the post, om 🙂

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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: