Alter Table Modify - Taking too long?
I ran the exact following statement:
Alter table THBK0 modify GL_ref char(9);
to alter the column gl_ref to char(9).. it was previously char(6). The table has around 20 columns and record count of 250,000. This statement ran for 3 hours and i had to kill it.
Can anyone help me, what is going on or wrong here? Thank you.
CHAR is padded with spaces, so EVERY row will have to be updated to add 3 space characters to the column.
Another reason to use VARCHAR2
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Originally Posted by bluemetal
I remember one instance happened 3 years ago. On a 200 M rows table, changing a column data type from varchar2(3) to char(3) ran for 3 days and never finished, finally we aborted it.
Click Here to Expand Forum to Full Width