Oracle 11G的间隔（INTERVAL）分区

-- Create table
create table MS_BIGTABLE_LOG
(
  record_date DATE,
  col_1       VARCHAR2(2000),
  col_2       VARCHAR2(2000)
  )
PARTITION BY RANGE (record_date)
  INTERVAL (numtodsinterval(1,‘day‘))
  (
           PARTITION P1 VALUES LESS THAN (TO_DATE(‘2014-1-1‘, ‘YYYY-MM-DD‘)),
           PARTITION P2 VALUES LESS THAN (TO_DATE(‘2014-1-2‘, ‘YYYY-MM-DD‘))
  );

create table FACT_YEAR
(
  stat_date   DATE
)
PARTITION BY RANGE (stat_date)
  INTERVAL (NUMTOYMINTERVAL (1,‘YEAR‘))
  (
           PARTITION P1 VALUES LESS THAN (TO_DATE(‘2014-1-1‘, ‘YYYY-MM-DD‘))
  );