偶然试了一下,发现Oracle10G的drop database命令还真省事

ride:
c:\>net start oracleservicesunny
OracleServiceSUNNY 服务正在启动 ...............
OracleServiceSUNNY 服务已经启动成功。
c:\>sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Dec 9 15:53:51 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle10i Enterprise Edition Release 10.1.0.0.0 - Beta
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
SQL> drop database;
drop database
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> alter database mount;
Database altered.
SQL> drop database;
drop database
*
ERROR at line 1:
ORA-12719: operation requires database is in RESTRICTED mode
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
System altered.
SQL> drop database;
Operation 203 succeeded.
SQL> select * from v$controlfile;
select * from v$controlfile
*
ERROR at line 1:
ORA-01034: ORACLE not available
SQL>