orcle 10g 創(chuàng)建分區(qū)表不能自動(dòng)創(chuàng)建，如果想自動(dòng)根據(jù)時(shí)間創(chuàng)建分區(qū)表需要寫腳本自動(dòng)增加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('11-4-2017', 'dd-mm-yyyy')),  PARTITION P7 VALUES LESS THAN (TO_DATE('21-4-2017', 'dd-mm-yyyy')),  PARTITION P8 VALUES LESS THAN (TO_DATE('1-5-2017', 'dd-mm-yyyy')),  PARTITION P9 VALUES LESS THAN (TO_DATE('11-5-2017', 'dd-mm-yyyy')),  PARTITION P10 VALUES LESS THAN (TO_DATE('21-5-2017', 'dd-mm-yyyy')))
alter table jcsj_sssj add constraints jcpk PRimary key (timetamp,tagname);--創(chuàng)建聯(lián)合主鍵，提供索引提高查詢效率