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.
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.
I am a regular follower of your blog and I have to admit that your post are very informative. This post explains how to drop database in Oracle 10g. The steps given in this post are very simple to implement.Have a look at the post may be you find the post useful for you.
ReplyDeleteno for all .. For freshers it is useful. might be u worked with different method.. but it is the same steps where we are dropping the database
ReplyDelete