Primary Key change of Table Structure

Requirement: Add a column location_no based on the existing table structure to make it one of the primary keys;
Add a non-primary key column only_allow;

Solution:
Step 1) Add two columns first
Alter table ht_limit_lot2_tab
Add
(Location_no varchar2 (50 ),
Only_allow varchar2 (5 ));

Step 2) default values for two columns
Update ht_limit_lot2_tab
Set location_no = '%', only_allow = 'false ';

Step 3) delete a primary key
Alter table ht_limit_lot2_tab
Drop primary key;

Step 4) Add a primary key.
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/