10G--10g中如何删除数据库

Requirements

• database must be closed,
• exclusively mounted,
• restricted

1. shutdown immediate;
2. startup mount exclusive restrict;
3. drop database;

SQL> shutdown immediate;
ORA-01109: 数据库未打开

已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount exclusive restrict;
ORACLE 例程已经启动。

Total System Global Area 176160768 bytes
Fixed Size 1289580 bytes
Variable Size 159384212 bytes
Database Buffers 8388608 bytes
Redo Buffers 7098368 bytes
数据库装载完毕。
SQL> drop database;

数据库已删除。

从 Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options 断开
SQL>

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

转载于:http://blog.itpub.net/29987/viewspace-52033/