Re: modify table column

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 29 Nov 2005 21:34:45 +0100
Message-ID: <438cbb67$0$24720$626a14ce@news.free.fr>

<t-ngo_at_ti.com> a écrit dans le message de news: 1133295609.326002.170600_at_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
|

This is just a modification in the dictionary, so this locks only the definition of the table for a short while. But this invalidates all cursors, procedures and so on depending on this table and so implies reloads and recompilations.

Be aware to keep the same definition on the columns that references this one (foreign key).

Regards
Michel Cadot Received on Tue Nov 29 2005 - 14:34:45 CST