ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Drop Database

Drop Database

原创 Linux操作系统 作者:yyp2009 时间:2013-07-18 19:31:50 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 9i dba_jobs_running
请登录后发表评论 登录
全部评论

注册时间:2008-10-17

  • 博文量
    330
  • 访问量
    1025056