Tuesday, December 4, 2012

0 Oracle Database(3): Drop database

Oracle 10g provide the “drop database” to drop the database.

shutdown immediate;
startup mount exclusive restrict; 
drop database;
image

The command does clean up the files except the parameter files ( I use init.ora not the spfile. ) and password file.

After the database is drop, the oracle instance is shutdown. You can use ps –ef to grep the ORACLE_SID and you will see the processes are no longer exist.

image

Reference

http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta019.htm

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates