CREATE INDEX IDX_WG030_3
ON TA_WG030 ( PART_DIV_FR,PART_NO_FR,PART_TYPE_FR,BRAND,SEASON_YEAR,SEASON)
INITRANS 2 MAXTRANS 255 PCTFREE 5
STORAGE (INITIAL 50 M NEXT 30 M
MINEXTENTS 1 MAXEXTENTS 255 PCTINCREASE 0)
LOCAL
(
partition IDX_WG030_2020 tablespace SWERP_INDEX,
partition IDX_WG030_2021 tablespace SWERP_INDEX,
partition IDX_WG030_MAX tablespace SWERP_INDEX)
alter table ta_wg010 add constraint PK_WG010
primary key(SLIP_DATE,PART_DIV_TO,PART_NO_TO,
PART_TYPE_TO, SLIP_NO,SLIP_SEQ)
using index storage(INITIAL 25600 K NEXT 25600 K)
local
(
partition pk_wg010_2020 tablespace SWERP_INDEX,
partition pk_wg010_2021 tablespace SWERP_INDEX,
partition pk_wg010_max tablespace SWERP_INDEX)