Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: List Partitioning

Re: List Partitioning

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 30 Jan 2006 08:54:06 -0800
Message-ID: <1138640043.257044@jetspin.drizzle.com>


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 .

A demo can be found in Morgan's Library at www.psoug.org. Click on Partitions.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Jan 30 2006 - 10:54:06 CST

Original text of this message

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