orcle 分区表创建、查询、知识总结

1.orcle 10g 创建分区表不能自动创建，

如果想自动根据时间创建分区表需要

写脚本自动增加partition

CREATE TABLE jcsj_sssj (  
  tagname VARCHAR2(128), 
  tagvalue VARCHAR2(128), 
  timetamp DATE  
) 
PARTITION BY RANGE (timetamp) 
(
  PARTITION P0 VALUES LESS THAN (TO_DATE('11-2-2017', 'dd-mm-yyyy')),
  PARTITION P1 VALUES LESS THAN (TO_DATE('21-2-2017', 'dd-mm-yyyy')),
  PARTITION P2 VALUES LESS THAN (TO_DATE('1-3-2017', 'dd-mm-yyyy')),
  PARTITION P3 VALUES LESS THAN (TO_DATE('11-3-2017', 'dd-mm-yyyy')),
  PARTITION P4 VALUES LESS THAN (TO_DATE('21-3-2017', 'dd-mm-yyyy')),
  PARTITION P5 VALUES LESS THAN (TO_DATE('1-4-2017', 'dd-mm-yyyy')),
  PARTITION P6 VALUES LESS THAN (TO_DATE(&