multi column range partitioning

From: cosmin ioan <cosmini_at_yahoo.com>
Date: 28 Mar 2003 16:43:54 -0800
Message-ID: <80fb0771.0303281643.4b32f2e3@posting.google.com>

hello all,
I have a multi column range partition as in the example below and I'm not understanding why when I insert data, it is placed in what appears to be the incorrect partition/tablespace.

thx much,
Cosmin

CREATE TABLE test_part
(

  WAVE_ID                NUMBER(10)             NOT NULL,
  PROB_TYPE              NUMBER(1)              NOT NULL)

PARTITION BY RANGE (WAVE_ID, PROB_TYPE) (
  PARTITION P5029_3 VALUES LESS THAN (5030, 4)     nologging
    TABLESPACE P5029_3
    PCTFREE 10
    INITRANS 1
    MAXTRANS 255
    STORAGE (

                INITIAL          64K
                MINEXTENTS       1
                MAXEXTENTS       2147483645
                BUFFER_POOL      DEFAULT


               ),  

  PARTITION P5029_4 VALUES LESS THAN (5030, 5)     NOLOGGING
    TABLESPACE P5029_4
    PCTFREE 10
    INITRANS 1
    MAXTRANS 255
    STORAGE (

                INITIAL          64K
                MINEXTENTS       1
                MAXEXTENTS       2147483645
                BUFFER_POOL      DEFAULT


               ),  

  PARTITION P5031_3 VALUES LESS THAN (5032, 4)     NOLOGGING
    TABLESPACE P5031_3
    PCTFREE 10
    INITRANS 1
    MAXTRANS 255
    STORAGE (

                INITIAL          64K
                MINEXTENTS       1
                MAXEXTENTS       2147483645
                BUFFER_POOL      DEFAULT


               ),  

  PARTITION P5031_4 VALUES LESS THAN (5032, 5)     NOLOGGING
    TABLESPACE P5031_4
    PCTFREE 10
    INITRANS 1
    MAXTRANS 255
    STORAGE (

                INITIAL          64K
                MINEXTENTS       1
                MAXEXTENTS       2147483645
                BUFFER_POOL      DEFAULT


               ),  

  PARTITION P5033_3 VALUES LESS THAN (MAXVALUE, MAXVALUE)     NOLOGGING
    TABLESPACE MS
    PCTFREE 10
    INITRANS 1
    MAXTRANS 255
    STORAGE (

                INITIAL          64K
                MINEXTENTS       1
                MAXEXTENTS       2147483645
                BUFFER_POOL      DEFAULT
               )

)
NOCACHE
NOPARALLEL; insert into test_part values (5029, 3);

insert into test_part values (5029, 4); --puts data in tablespace P5029_3!!!;

insert into test_part P5029_4 values (5029, 4); --also puts data in tablespace P5029_3 !!! Received on Fri Mar 28 2003 - 18:43:54 CST