表分区sql脚本

–建表
create table xxx.wrk_info (
–建字段
id_key varchar2(32) default SYS_GUID()not null,
tag_type varchar2(32) ,
PARTITION_NO NUMBER(2) defalut(0) not null,
BATCH_NO varchar2(50) defalut(‘0’) not null

)INITRANS 6 MONITORING
PARTITION BY RANGE (PARTITION _NO)(
PARTITION PT_WRK_INFO_P0 VALUES less then(1),
PARTITION PT_WRK_INFO_P0 VALUES less then(2),
PARTITION PT_WRK_INFO_P0 VALUES less then(3),
PARTITION PT_WRK_INFO_P0 VALUES less then(4),
PARTITION PT_WRK_INFO_P0 VALUES less then(5),
PARTITION PT_WRK_INFO_PM VALUES less then(Maxvalue)
–5个分区
);
comment on table xxx.wrk_info is ‘xxx表’;
comment on table xxx.wrk_info.id_key is ‘主键’;
comment on table xxx.wrk_info.tag_type is ‘标签type’;
comment on table xxx.wrk_info.PARTITION_NO is ‘分区号’;

–主键索引
CREATE UNIQUE INDEX XXX.PK-WRK-INFO ON XXX.WRK_INFO(ID_KEY) INITRANS 16 ONLINE;

ALTER TABLE XXX.WRK_INFO ADD CONSTRANT PK_WRK_INFO PRIMARY KEY (ID_KEY)
USING INDEX XXX.PK_WRK_INFO;

CREATE INDEX XXX.IX_INFO_PN ON XXX.WRK_INFO (PARTITION_NO) GLOBAL INITRANS 16 online;
CREATE INDEX XXX.IX_INFO_PN ON XXX.WRK_INFO (BATCH_NO) local INITRANS 16 online;