Re: Table partition: question

The short answer would be NO.

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.

HTH. "darkeagle" <NOSPAM_at_italy.it> wrote in message news:<2m1kt7Fhnd71U1_at_uni-berlin.de>...
> Hi all,
> I have a question:
> It is possibile to use a SQL function (like SubStr) in the partition by Hash
> clause of a Create table sentence?
> Ex: if I try
> Create Table a(
> info VARCHAR(8) Not Null
> )
> PARTITION BY HASH (SubStr(info,5,2))
> PARTITIONS 12
> I obtain an error: ORA-00900 invalid SQL Statement.
> Can anyone help me?
> Thank you.
> G
Received on Mon Jul 19 2004 - 08:41:16 CDT