如何不使用DBCA在Oracle 11中刪除數(shù)據(jù)庫(kù)
作者:VicYu/Vic020
本文簡(jiǎn)短的教程,將會(huì)向你展示如何不使用DBCA(數(shù)據(jù)庫(kù)配置助手)在Oracle 11中刪除數(shù)據(jù)庫(kù)。
本文簡(jiǎn)短的教程,將會(huì)向你展示如何不使用DBCA(數(shù)據(jù)庫(kù)配置助手)在Oracle 11中刪除數(shù)據(jù)庫(kù)。
1- 導(dǎo)入數(shù)據(jù)庫(kù)的SID,如果沒(méi)有定義的話
- export ORACLE_SID=database
2- 以操作系統(tǒng)認(rèn)證連接數(shù)據(jù)庫(kù)
- [oracle@Oracle11 ~]$ sqlplus / as sysdba
- SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 1 17:38:02 2014
- Copyright (c) 1982, 2009, Oracle. All rights reserved.
- Connected to an idle instance.
3- 啟動(dòng)數(shù)據(jù)庫(kù)實(shí)例
- SQL> startup
- ORACLE instance started.
- Total System Global Area 3340451840 bytes
- Fixed Size 2217952 bytes
- Variable Size 1828718624 bytes
- Database Buffers 1493172224 bytes
- Redo Buffers 16343040 bytes
- Database mounted.
- Database opened.
4- 關(guān)閉數(shù)據(jù)庫(kù)
- SQL> shutdown immediate;
- Database closed.
- Database dismounted.
- ORACLE instance shut down.
5- 啟動(dòng)獨(dú)占模式
- SQL> startup mount exclusive restrict
- ORACLE instance started.
- Total System Global Area 3340451840 bytes
- Fixed Size 2217952 bytes
- Variable Size 1828718624 bytes
- Database Buffers 1493172224 bytes
- Redo Buffers 16343040 bytes
- Database mounted.
6- 刪除數(shù)據(jù)庫(kù)
- SQL> drop database;
- <br>Database dropped.
- Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
- With the Partitioning, OLAP, Data Mining and Real Application Testing options
完成!
via: http://www.unixmen.com/drop-database-oracle-11-without-using-dcba/
作者:M.el Khamlichi 譯者:VicYu/Vic020 校對(duì):wxy
責(zé)任編輯:林師授
來(lái)源:
Linux中國(guó)