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
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