Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: List Partitioning
Sreelal wrote:
> 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 .
>
All well, and valid responses, but are you reinventing the wheel, Oracle sells as the ConText option?
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Mon Jan 30 2006 - 12:32:59 CST
![]() |
![]() |