Admin/admin

Dropping a Database in 10G

Qhtlr 2007. 8. 17. 09:04
sqlplus "/as sysdba"
SQL> startup nomount;

SQL> alter database mount exclusive;

SQL> alter system enable restricted session;

SQL> select name from v$database;

NAME
---------
TEST
삭제할 데이타베이스가 맞는지 다시 한 번 확인한다.

SQL> drop database;

Database dropped.

Database is dropped & all related files are deleted automatically.