针对一道最近很火的面试题如何不使用DBCA在Oracle 11中删除数据库

she说he说

1- 导入数据库的SID，如果没有定义的话
export ORACLE_SID=database
2- 以操作系统认证连接数据库
[oracle@Oracle11 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production onMon Dec 1 17:38:02 2014Copyright (c) 1982, 2009, Oracle. All rightsreserved.Connected to an idle instance.
3- 启动数据库实例
SQL> startup ORACLE
instancestarted.Total System Global Area3340451840 bytesFixed Size 2217952 bytesVariable Size 1828718624 bytesDatabaseBuffers 1493172224 bytesRedo Buffers 16343040 bytesDatabasemounted.Databaseopened.
4- 关闭数据库
SQL> shutdown immediate;
Database closed.Databasedismounted.ORACLEinstance shut down.
5- 启动独占模式
SQL> startup mount exclusive restrict
ORACLE instance started. Total SystemGlobal Area 3340451840 bytesFixed Size 2217952 bytesVariable Size 1828718624bytesDatabase Buffers 1493172224 bytesRedo Buffers 16343040 bytesDatabasemounted.
6- 删除数据库
SQL> drop database;
<br>Database dropped. Disconnectedfrom Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bitProductionWith the Partitioning, OLAP, Data Mining and Real Application Testingoptions
ok数据库被删掉了

具体请看武汉银河爱飞官方论坛，更多惊喜等着你！！