表结构之主键变更

需求：在现有表结构基础上增加一栏位location_no 使之成为主键之一;
           另增加一非主键栏位only_allow ;

解决方案：
STEP1)  先增加两栏位
alter table ht_limit_lot2_tab
  add
    ( location_no varchar2(50),
      only_allow varchar2(5));

STEP2)  两栏位Default值
update ht_limit_lot2_tab
set location_no = '%',only_allow = 'FALSE';

STEP3) 主键删除
alter table ht_limit_lot2_tab
drop PRIMARY key ;

STEP4) 再增加主键
ALTER TABLE ht_limit_lot2_tab
   ADD ( CONSTRAINT ht_limit_lot2_pk PRIMARY KEY ( contract, customer_id, address_id, part_no, lot_no, location_no)
         USING INDEX
               TABLESPACE IFSAPP_INDEX
               ); 

                                                       By foreveryday007 20060719
                                                       http://blog.csdn.net/foreveryday007/