Drop Database

最新推荐文章于 2025-11-24 15:52:05 发布

转载最新推荐文章于 2025-11-24 15:52:05 发布 · 137 阅读

文章标签：

#数据库

本文详细记录了一次尝试从Oracle数据库实例中删除数据库时遇到的问题，特别是当数据库处于非限制模式时，执行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/