CREATE INDEX ix_test_1 ON t_test(tdate)
GLOBAL PARTITION BY RANGE(tdate)
(
PARTITION t_1 VALUES LESS THAN(to_date('2007-01-11','yyyy-mm-dd'))
TABLESPACE dingyu220_idx
PCTFREE 10
INITRANS 10
MAXTRANS 255
STORAGE(
INITIAL 10k
NEXT 1m
MINEXTENTS 1
MAXEXTENTS UNLIMITED
),
PARTITION t_2 VALUES LESS THAN(to_date('2007-01-21','yyyy-mm-dd'))
TABLESPACE dingyu220_idx
PCTFREE 10
INITRANS 10
MAXTRANS 255
STORAGE(
INITIAL 10k
NEXT 1m
MINEXTENTS 1
MAXEXTENTS UNLIMITED
),
PARTITION t_3 VALUES LESS THAN(MAXVALUE)
TABLESPACE dingyu220_idx
PCTFREE 10
INITRANS 10
MAXTRANS 255
STORAGE(
INITIAL 10k
NEXT 1m
MINEXTENTS 1
MAXEXTENTS UNLIMITED
)
)
GLOBAL PARTITION BY RANGE(tdate)
(
PARTITION t_1 VALUES LESS THAN(to_date('2007-01-11','yyyy-mm-dd'))
TABLESPACE dingyu220_idx
PCTFREE 10
INITRANS 10
MAXTRANS 255
STORAGE(
INITIAL 10k
NEXT 1m
MINEXTENTS 1
MAXEXTENTS UNLIMITED
),
PARTITION t_2 VALUES LESS THAN(to_date('2007-01-21','yyyy-mm-dd'))
TABLESPACE dingyu220_idx
PCTFREE 10
INITRANS 10
MAXTRANS 255
STORAGE(
INITIAL 10k
NEXT 1m
MINEXTENTS 1
MAXEXTENTS UNLIMITED
),
PARTITION t_3 VALUES LESS THAN(MAXVALUE)
TABLESPACE dingyu220_idx
PCTFREE 10
INITRANS 10
MAXTRANS 255
STORAGE(
INITIAL 10k
NEXT 1m
MINEXTENTS 1
MAXEXTENTS UNLIMITED
)
)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24805255/viewspace-721216/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
