Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> modify table column

modify table column

From: <t-ngo_at_ti.com>
Date: 29 Nov 2005 12:20:09 -0800
Message-ID: <1133295609.326002.170600@g44g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US