Re: Oracle Partitioning

It is unlikely you can create such a partition table because the partitioning of the table is according to ONE upper bound value not a list of values you defined. If 126 is the largest airline code and you can treat airline code '000' as null, then you can create a table with two partitions:

create table tablename .........

                  partition by range (airlinecode)
                        (partition pc values less than ('126') ......,
                         partition pd values less than (maxvalue) ....);

all your '126' and '000' airline information will be stored in partition pd and the rest will be stored in pc.

HTH John Chiu

<Gordan Freeman> wrote in message news:38213dd1.149153581_at_158.152.254.65...
> I want to partition a table containing information about airlines by
> their airline code - 3 alphanumerics. I want one partition to contain
> ailrine codes 000 and 126 and the other for the remainder of the
> codes, but I've not been able to manage it.
>
> As anybody manage to partition a table in such a manner.
>
> Matthew
Received on Thu Nov 04 1999 - 05:20:36 CST