List Partitioning

From: Sreelal <sreelalpp_at_gmail.com>
Date: 30 Jan 2006 05:22:32 -0800
Message-ID: <1138627352.723154.49160@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 . Received on Mon Jan 30 2006 - 07:22:32 CST