orcle11g 创建分区表

orcle 11g 创建分区表自动根据每天创建分区表从2011-1-1号以后

CREATE TABLE jcsj_sssj (  
  tagname VARCHAR2(128), 
  tagvalue VARCHAR2(128), 
  timetamp DATE
) 
PARTITION BY RANGE (timetamp) 
INTERVAL(NUMTOYMINTERVAL(1, 'day')) --自动创建语句
(
  PARTITION P0 VALUES LESS THAN (TO_DATE('1-1-2011', 'dd-mm-yyyy'))
);