Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Table partition: question

Re: Table partition: question

From: darkeagle <NOSPAM_at_italy.it>
Date: Mon, 19 Jul 2004 16:04:44 +0200
Message-ID: <2m22nuFhu2eoU1@uni-berlin.de>


> PARTITION BY HASH ({column_name}) would only accept, well, a column
> name. Hash partitioning is mostly used in order to achieve even
> distribution of your data. Would be interesting to know what you're
> trying to do.

In my case, the field Info VarChar(8) hold a concatenation of moer information.
I would create a hash partition based, for example, only on third character of this field.
You think this is possible?
Thank you. Received on Mon Jul 19 2004 - 09:04:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US