有朋友問(wèn)到關(guān)于Oracle的Dual表問(wèn)題，并且提到了Tom的一個(gè)鏈接：http://asktom.oracle.com/pls/asktom/f？p=100：11：0：：：：P11_QUESTION_ID：1562813956388 很多人關(guān)心的是Dual的內(nèi)部實(shí)現(xiàn)，這Oracle自然是不會(huì)披露的，不過(guò)我們可以從一些有限的資料獲得關(guān)于Dual的印象：

There is internalized code that makes this happen. Code checks that ensure that a table scan of SYS.DUAL only returns one row. Svrmgrl behaviour is incorrect but this is now an obsolete product.

The base issue you should always remember and keep is: DUAL table should always have 1 ROW. Dual is a normal table with one dummy column of varchar2(1).This is basically used from several applications as a pseudo table for getting results from a select statement that use functions like sysdate or other prebuilt or application functions. If DUAL has no rows at all some applications (that use DUAL) may fail with NO_DATA_FOUND exception. If DUAL has more than 1 row then applications (that use DUAL) may fail with TOO_MANY_ROWS exception.

So DUAL should ALWAYS have 1 and only 1 row.

前兩句話最為關(guān)鍵，實(shí)際上我們也容易猜到，Oracle通過(guò)內(nèi)部代碼來(lái)實(shí)現(xiàn)對(duì)于DUAL的訪問(wèn)和控制，并且通過(guò)Internal Code使得這個(gè)表與眾不同。

Tom提到在Close了Database之后，可以看到這個(gè)表的內(nèi)存地址及展現(xiàn)，這說(shuō)明這個(gè)表的結(jié)構(gòu)并不單純：

sql> select * from dual; D-X

sql> alter database close;

Database altered.

sql> select * from dual;

ADDR; INDX;INST_ID D-------- ---------- ---------- -0A4F8858; 0; 1 X

注意不要更改Dual表的內(nèi)容，否則可能引起數(shù)據(jù)庫(kù)的問(wèn)題。

如果該表意外刪除，可以通過(guò)設(shè)置初始化參數(shù)replication_dependency_tracking = FALSE，重啟數(shù)據(jù)庫(kù)來(lái)重建該表。