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 )

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: