Re: Table partition: question

• Post for FREE via your newsreader at post.usenet.com ****

Hi

> 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.

As you have verified it is not possible. This is also not a problem if you want to use hash partitioning, anyway you don't have the control on the hash function that is used to spread data over the partitions.

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=