Re: Multi Partition Types

On Nov 4, 6:16 pm, Mark D Powell <Mark.Pow..._at_eds.com> wrote:

> http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/partit...
Thanks Powell

I did some exercise and found some results which are confusing me I partitioned my table by Range

CREATE TABLE Orders (
  RegionID NUMBER(4,0),
  Date DATE,
  ProductCategory NUMBER(4,0)
)
PARTITION BY RANGE(Date, RegionID, ProductCategory) (
PARTITION r1 VALUES LESS THAN (To_Date('01/JAN/2009','DD/MON/YYYY'), 1000, 1000),
PARTITION r11 VALUES LESS THAN (To_Date('01/JAN/2009','DD/MON/YYYY'), 5000, 5000),
PARTITION r2 VALUES LESS THAN (To_Date('01/JAN/2010','DD/MON/YYYY'), 5000, 5000),
PARTITION r3 VALUES LESS THAN (MAXVALUE, MAXVALUE, MAXVALUE ) )
And inserted values as

insert into Orders VALUES ('01/JAN/2008',2, 1)
insert into Orders VALUES ('01/JAN/2008',4000, 1)
insert into Orders VALUES ('01/JAN/2008',4000, 8000)
insert into Orders VALUES ('01/JAN/2011',2500, 1)
insert into Orders VALUES ('01/JAN/2019',3000, 6000)
insert into Orders VALUES ('01/JAN/2019',1, 1)

and found that

row 1 went into r1
row 2 went into r1
row 3 went into r1
row 4 went into r2
row 5 went into r3
row 6 went into r3

r11 is empty !!!
Would you clarify how data is distributed, when all partitions will be hit and when some of them

Thanks again Powell Received on Tue Nov 04 2008 - 23:37:24 CST