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 -> Table partition: question

Table partition: question

From: darkeagle <NOSPAM_at_italy.it>
Date: Mon, 19 Jul 2004 12:08:37 +0200
Message-ID: <2m1kt7Fhnd71U1@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 - 05:08:37 CDT

Original text of this message

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