Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Table partition: question
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 - 05:08:37 CDT