oracle 11g 分区之五：间隔分区

郑全

CREATE TABLE  SALES_HISTORY_2006
  (
   PROD_ID NUMBER NOT NULL,
  CUST_ID NUMBER NOT NULL,
  TIME_ID DATE NOT NULL,
  CHANNEL_ID NUMBER NOT NULL,
  PROMO_ID NUMBER NOT NULL,
  QUANTITY_SOLD NUMBER(10,2) NOT NULL,
  AMOUNT_SOLD NUMBER(10,2) NOT NULL
  )
PARTITION BY RANGE (TIME_ID)
   interval (numtoyminterval('1','month'))
(PARTITION "SAL1" VALUES LESS THAN (TO_DATE('1/1/2002','MM/DD/YYYY')),
  PARTITION "SAL2" VALUES LESS THAN (TO_DATE('1/1/2003','MM/DD/YYYY')),
  PARTITION "SAL3" VALUES LESS THAN (TO_DATE('1/1/2004','MM/DD/YYYY')),
  PARTITION "SAL4" VALUES LESS THAN (TO_DATE('1/1/2005','MM/DD/YYYY'))
  );