Sunday, April 24, 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.