Re: Partitioning of a table

From: Klaus Zeuch <KZeuch_at_nospamhotmail.com>
Date: 2000/07/22
Message-ID: <8laihv$om4$15$1@news.t-online.com>#1/1

As Oracle only offers range partitioning and hash partitioning (using an internal hash function) that result is not possible. Currently you can't replace the internal hash-function with a user-defined hash function.

Klaus
"Madhavan Amruthur" <mad5698_at_my-deja.com> schrieb im Newsbeitrag news:8la07o$l69$1_at_nnrp1.deja.com...
> Hi,
> I have a requirement to partition a table based on a column as below
>
> table_name - products
> column name - product_type
>
> The values for the column
> 0
> A
> C
> F
> H
> K
> P
> <null>
>
> The requirement is A,F,H,K and P go into their own partitions and C,0
> and <null> should go into one partition.
>
> Is this possible?
>
> Thanks for your help in advance.
> Regards,
>
> --
> Madhavan
> IBM Corporation WebServer Division
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Jul 22 2000 - 00:00:00 CDT