Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Partitioning of a table
Thanks Klaus.
That was my understanding and thanks for confirming it.
Regards,
Madhavan
In article <8laihv$om4$15$1_at_news.t-online.com>,
"Klaus Zeuch" <KZeuch_at_nospamhotmail.com> wrote:
> 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.
>
>
-- Madhavan IBM Corporation WebServer Division Sent via Deja.com http://www.deja.com/ Before you buy.Received on Fri Jul 21 2000 - 00:00:00 CDT