Multi-Column Partitions

From: Mike Winterer <mikew3_at_corp.earthlink.net>
Date: 2000/03/17
Message-ID: <38D2C0DD.87430372@corp.earthlink.net>#1/1

I am having trouble getting data to be distributed to the appropriate partitions. Using the definition below, all of the data is inserted into the the first partition. This happens even if the dates are actually spread over the various dates. It may be a cause of multiple date columns in the partition definition. Can anyone help on this?

CREATE TABLE um_usage
(

  usage_type_code        NUMBER,
  userid                 VARCHAR2(50) NOT NULL,
  starttime              DATE         NOT NULL,
  endtime                DATE         NOT NULL

)
PARTITION BY RANGE (usage_type_code,endtime,starttime)   (
    PARTITION p_um_usage_20000101_10 VALUES LESS THAN ( 11, TO_DATE('01-JAN-2000','DD-MON-YYYY'),TO_DATE('01-JAN-2000','DD-MON-YYYY')),     PARTITION p_um_usage_20000102_10 VALUES LESS THAN ( 11, TO_DATE('02-JAN-2000','DD-MON-YYYY'),TO_DATE('02-JAN-2000','DD-MON-YYYY')),     PARTITION p_um_usage_20000103_10 VALUES LESS THAN ( 11, TO_DATE('03-JAN-2000','DD-MON-YYYY'),TO_DATE('03-JAN-2000','DD-MON-YYYY')),    ...
  ) Received on Fri Mar 17 2000 - 00:00:00 CST