删除数据库的通常方法是使用dbca。如果不是用dbca，也可以使用drop database的方法，下面演示其过程：

1、启动数据库到mount状态

ora_test@oracle[/home/oracle]> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Feb 8 22:59:07 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

idle> startup mount;
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1218292 bytes
Variable Size 71305484 bytes
Database Buffers 88080384 bytes
Redo Buffers 7168000 bytes
Database mounted.

[@more@]

2、限制session登录

idle> alter system enable restricted session;

System altered.

3、删除数据库

idle> 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
idle> exit

4、清理其他文件

ora_test@oracle[/home/oracle]> cd $ORACLE_HOME/dbs
ora_test@oracle[/oracle/app/10.1/dbs]> rm -rf *cnhtm*
ora_test@oracle[/oracle/app/10.1/dbs]> rm -rf *CNHTM*

ora_test@oracle[/oracle/app/10.1/dbs]> cd $ORACLE_BASE/admin
ora_test@oracle[/oracle/admin]> rm -rf cnhtm

--end--

ITPub博客

手动删除数据库

最新文章