In this post we will see how to drop the oracle database.
1.connect sqlplus and shutdown the database.
Shut immediate;
2.Once db down mount the database with restricted mode.
startup mount restrict;
3.Post that issue drop database command to drop the database.it will remove all db related files and clear the space for that database.
DROP DATABASE;
after drop the database remove the tns entries and listener entries in oracle home.
$ORACLE_HOME/network/admin/listener.ora
$ORACLE_HOME/network/admin/tnsnames.ora
1.connect sqlplus and shutdown the database.
Shut immediate;
2.Once db down mount the database with restricted mode.
startup mount restrict;
3.Post that issue drop database command to drop the database.it will remove all db related files and clear the space for that database.
DROP DATABASE;
after drop the database remove the tns entries and listener entries in oracle home.
$ORACLE_HOME/network/admin/listener.ora
$ORACLE_HOME/network/admin/tnsnames.ora
No comments:
Post a Comment