原来的索引是不带LOCAL的,现在修改为这种形式
create index IDX_BTR_ZNO_OPCODE_BARTIME on TBILLTRACE(ZNO, OPCODE, BARTIME)
TABLESPACE "EXP4_TBILLTRACE_IDX02" PCTFREE 10 INITRANS 2
MAXTRANS 255
STORAGE ( INITIAL 102400K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL KEEP)
NOLOGGING
local
(
partition TBILLTRACE_M8 tablespace BTR_ZNO_OPCODE_BARTIME_P08 logging pctfree 10,
partition TBILLTRACE_M9 tablespace BTR_ZNO_OPCODE_BARTIME_P09 logging pctfree 10,
partition TBILLTRACE_M10tablespace BTR_ZNO_OPCODE_BARTIME_P10 logging pctfree 10,
partition TBILLTRACE_M11tablespace BTR_ZNO_OPCODE_BARTIME_P11 logging pctfree 10,
partition TBILLTRACE_M12tablespace BTR_ZNO_OPCODE_BARTIME_P12 logging pctfree 10
) ONLINE
/ |