oracle分區(qū)表是不是有最大分區(qū)個(gè)數(shù)限制,我有一張大約20G的表,有好多分區(qū)(按時(shí)間),結(jié)果根據(jù)這個(gè)時(shí)間條件查詢就報(bào)ORA-03113 end-of-file on communication channel錯(cuò)誤,然后斷開鏈接,硬件與網(wǎng)絡(luò)都沒問題. 后來我刪了幾個(gè)分區(qū)就一切OK了,這是咋回事呢? 系統(tǒng)環(huán)境 win2003 server + oracle9201

我猜測他這個(gè)問題并非遇到了分區(qū)個(gè)數(shù)的限制,，因?yàn)檫@個(gè)限制很難達(dá)到,，至少到目前為止我尚未聽說有人達(dá)到這個(gè)分區(qū)限制。

那么Oracle最大允許存在多少個(gè)分區(qū)呢?

我們可以從Oracle的Concepts手冊上找到這個(gè)信息,，對于Oracle9iR2:

Tables can be partitioned into up to 64,000 separate partitions.

對于Oracle10gR2,，Oracle增強(qiáng)了分區(qū)特性：

Tables can be partitioned into up to 1024K-1 separate partitions.

真的會有人嘗試來突破這個(gè)分區(qū)極限嗎? 你的數(shù)據(jù)庫最大的分區(qū)表有多少個(gè)分區(qū)呢?

關(guān)于何時(shí)應(yīng)該進(jìn)行分區(qū),Oracle有如下建議:

■ Tables greater than 2GB should always be considered for partitioning.
■ Tables containing historical data, in which new data is added into the newest partition. A typical example is a historical table where only the current month's data is updatable and the other 11 months are read only.

 

歷史上的今天...
    >> 2012-01-18文章:

           ACOUG 2012年2月 Ask Tom and Eygle - 上海

    >> 2010-01-18文章:

           SQL 共享之 ROLL_INVALID_MISMATCH 含義

By eygle on 2006-01-18 14:58 | Comments (1) | FAQ | 642 |