创建带分区的表

 CREATE TABLE TMC_HISTORY_PUBLISH_4201 
(
  CYCLE        DATE,
  LOCATIONID   INTEGER,
  DIRECTION    INTEGER,
  SPEED        INTEGER,
  EVENT        INTEGER,
  FLOW         INTEGER,
  DENSITY      INTEGER,
  FLAG         CHAR(1),
  CELLULARTIME VARCHAR2(20),
  FINISHTIME   DATE
)
PARTITION BY RANGE (CYCLE)
INTERVAL(NUMTODSINTERVAL(1,'hour')) 
(PARTITION WH201506110100_LS VALUES LESS THAN (TO_DATE('2015-06-11 01:00:00','YYYY-MM-DD HH24:MI:SS')) TABLESPACE RTT);