Re: Limit on number of values for list partition?

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Wed, 05 Mar 2003 10:44:56 +0100
Message-ID: <h3hb6v0kjs6bf0p6aiv2b0g8qmgp64jh31@4ax.com>

On Tue, 04 Mar 2003 22:11:58 GMT, "M2" <me_at_quietplaceiwithnospam.com> wrote:

...
> If I have a range that says LESS THAN ('200341') (to ensure
>"200340" fits) then does "200270" get placed within this partition? I assume
>it does unless I create another range for LESS THAN ('200271') but what
>happens then? "200270" is seemingly suitable for both partitions. I am
>assuming that Oracle will go for the "best match" and that "200270" will be
>destined for the "200271" partition otherwise I don't understand how it can
>ever work. Are these assumptions valid?
...

Yes, that's how it works, although you cannot create the partition because it is does not have a higher value than the existing partitions. Instead, you have to split the 200341 partition (alter table split partition...) and name the 200341 partition as the highest partition. Check your index partitions of 200341 though: Oracle will put them in the default tablespace of the index (in USER_INDEXES).

Jaap. Received on Wed Mar 05 2003 - 03:44:56 CST