Archive | January 2011

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;