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/,如需转载,请注明出处,否则将追究法律责任。