Wednesday, 6 March 2013

How to Drop Database in Oracle 10g????

Dropping a database is really easy with oracle 10g. Earlier in order to drop a database it was required to manually remove all the datafiles, control files, redo, logfiles and init.ora, password file etc but with oracle 10g dropping a database is a single command.
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;

SQL> startup restrict mount;

SQL> drop database;
Database dropped

SQL> exit


No comments:

Post a Comment