午夜国产狂喷潮在线观看|国产AⅤ精品一区二区久久|中文字幕AV中文字幕|国产看片高清在线

如何不使用DBCA在Oracle 11中刪除數(shù)據(jù)庫(kù)

1- 導(dǎo)入數(shù)據(jù)庫(kù)的SID，如果沒有定義的話

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

更多信息請(qǐng)查看IT技術(shù)專欄