modify table column

Hello,
We have a partitioned table with more than 30M rows. We want to increase the size of varchar2 data type, this column is part of primary key. Do you see any impact when doing this. Will Oracle lock the whole table for a long time since it has more than 30M rows?

alter table table_name modify (column_name varchar2(size));

Thanks in advance for you response.

Thanh Received on Tue Nov 29 2005 - 14:20:09 CST