ALTER TABLE wash_fail DROP PRIMARY KEY;
drop index IX_WASH_FAILS_MD5_CODE;
create index IX_WASH_FAILS_MD5_CODE on WASH_FAIL (MD5_CODE)
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 1M
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table WASH_FAIL
add primary key (ID)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 1M
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
01-21
04-27
398

10-06
6295
