CREATE INDEX ix_test ON t_test(tmmdd)
       LOCAL
      --GLOBAL PARTITION BY RANGE(tmmdd)
       (
        PARTITION tp_1 --VALUES LESS THAN('0111')
          TABLESPACE dingyu220_idx
           PCTFREE 10
           INITRANS 10
           MAXTRANS 255
          STORAGE(
           INITIAL 10k
           NEXT 1m
           MINEXTENTS 1
           MAXEXTENTS UNLIMITED    
          ),
        PARTITION tp_3 --VALUES LESS THAN(MAXVALUE)
          TABLESPACE dingyu220_idx
           PCTFREE 10
           INITRANS 10
           MAXTRANS 255
          STORAGE(
           INITIAL 10k
           NEXT 1m
           MINEXTENTS 1
           MAXEXTENTS UNLIMITED    
          )
       )

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24805255/viewspace-721214/，如需转载，请注明出处，否则将追究法律责任。