Re: Table partition: question

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 19 Jul 2004 05:30:38 -0700
Message-ID: <1090240260.477526@yasure>

darkeagle wrote:

> 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

Why don't you believe the message?
What do you think you will accomlish by hashing a substring?

Daniel Morgan Received on Mon Jul 19 2004 - 07:30:38 CDT