Drop Database

SQL> conn / as sysdba;
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.

Total System Global Area  272629760 bytes
Fixed Size                  1218944 bytes
Variable Size             167773824 bytes
Database Buffers           96468992 bytes
Redo Buffers                7168000 bytes
dop Database mounted.
SQL>drop database;
SP2-0734: unknown command beginning "dopdrop da..." - rest of line ignored.
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;
drop database
*
ERROR at line 1:
ORA-01586: database must be mounted EXCLUSIVE and not open for this operation

SQL> alter system enable restricted session;

SQL> drop database;
drop database
*
ERROR at line 1:
ORA-01586: database must be mounted EXCLUSIVE and not open for this operation

SQL>  alter database close;

Database altered.

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13750068/viewspace-766641/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13750068/viewspace-766641/