Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Altering char(2) to char(4) causing entire table rewrite?
I need to alter a char(2) field in a table to char(4). At present this column is null for all rows in the table (over 3 million rows, total table size around 300MB.)
However, when I attempt to make the change, it looks like it is rewriting every row in the table, because it is producing great quantities of archive logs. This brings my production users to a grinding halt.
Is there any way around this, or am I going to have to schedule this modification to run over a weekend?
-- Mike Nolan nolan_at_inetnebr.comReceived on Wed Dec 11 1996 - 00:00:00 CST
![]() |
![]() |