Drop and Recreate PK Index

Disable PK constraint. alter table TBL1 disable constraint PK_TBL1 ; Delete PK index. alter table TBL1 drop index PK_TBL1 ; Create PK index. create unique index "PK_TBL1" on "TBL1" ("INSPECTORID", "DUTYID", "INSPID") tablespace "TBLSPCINDX" pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K next 0K minextents 1 maxextents 2147483645 pctincrease 0 freelists 1 freelist groups 1 ) nologging; Enable PK constraint. alter table "TBL1" enable constraint "PK_TBL1" ;