Home » RDBMS Server » Server Administration » oracle partition by list for multiples colonnes
oracle partition by list for multiples colonnes [message #176207] Wed, 07 June 2006 06:01 Go to next message
ziyati
Messages: 4
Registered: June 2006
Location: morocco
Junior Member
Hi all

i have a problem with partitioning a table according to tree colonnes
for example
Client (Code , SEX , TOWN, Adresse, Product)

crrate table client (...)

partition by list (SEX , TOWN, Product)
you can put what you want in the values area
SEX(F, M)
TWN( 'NY', 'TX', 'DC')
Product ('TID', 'ED' ,'GE' )

thanks in advance

Report message to a moderator

Re: oracle partition by list for multiples columns [message #176350 is a reply to message #176207] Thu, 08 June 2006 01:26 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
It cannot be done - you can only list partition on one column. As workaround, concatenate your columns into one or choose another partitioning method.

Report message to a moderator

Previous Topic: advice on Extent size in tablespace in 10.2.0.2
Next Topic: Can an Oracle DML statement use many rollback segments?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:28:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.