-- drop tabledrop table LDUSERLOGONLOG;-- Create tablecreate table LDUSERLOGONLOG(  usercode     VARCHAR2(20) ,  userclientip VARCHAR2(15) ,  modifydate   DATE ,  modifytime   VARCHAR2(8) ,  com VARCHAR2(20) ,  flag CHAR(20))--以MODIFYDATE列分區建表， PARTITION BY RANGE (MODIFYDATE)      INTERVAL (NUMTOYMINTERVAL(1, 'MONTH'))--特定方法，自動分區      (         PARTITION p0 VALUES LESS THAN (TO_DATE ('2017-01-01', 'YYYY-MM-DD'))         );-- Create/Recreate indexes create index IDX_usercode on LDUSERLOGONLOG (usercode)  local;--上面的例子表示除了上面已經定義的分區以外，每個月只要有數據，就會新建一個分區。INTERVAL(NUMTOYMINTERVAL(1, 'MONTH')) 按月INTERVAL (NUMTODSINTERVAL(1,’DAY’)) 按天INTERVAL(NUMTOYMINTERVAL(1, 'YEAR'))  按年