Hi all, The problem was if there were indices referencing the column, the indices didn't get dropped and recreated afterwards just like foreign key constrains. For primary key columns, it's the primary key constrain needs to be take care of (drop before alter the column and recreate afterwards).
-------------- Cheers, Jun
