Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: List Partitioning
"Sreelal" <sreelalpp_at_gmail.com> a écrit dans le message de news: 1138627352.723154.49160_at_z14g2000cwz.googlegroups.com...
| Hi,
|
| this is related to list partitioning.
|
| i want to partition a table based on one column' s value( name varchar2
| (10)) . there will be three partitions. all the name , start with vowel
| , should go in the first partition and all the names start with
| consonant, should go into second partition and rest of them, means
| names start with other characters like ( &, %, # , etc .) should go
| into third partition.
|
| can anybody sugest the proper create table command with partition .
|
Add a new column with only the first character and filled by trigger.
Then the partitioning definition is quite easy:
create table ...
partition by list (newcol)
(partition vowel values ('a','e','i','o','u','y'),
partition consonant values ('b','c'...),
partition others values(default))
/
Regards
Michel Cadot
Received on Mon Jan 30 2006 - 10:54:50 CST