Thursday, July 14, 2011

How to Drop Database in Oracle 10g

In order to drop the database start the database in restrict mode and bring it in mount state as shown:
sqlplus / as sysdba
SQL> shutdown immediate;
oracle database closed
oracle database dismounted
oracle instance shutdown
SQL> startup restrict mount;
SQL> drop database;
Database dropped
SQL> exit
Thus u will find that all the files associated with the database will be deleted.

Apps DBA
Sukhwinder Singh

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.