alter column size will failed
SagiGalOct 29 2012 — edited Oct 30 2012Hi All,
I have a question on oracle 10g. I am going to alter one of the table column type from varchar(100) to varchar(200).
Initially i plan to alter the table to readonly mode then modify the column.
But I hit the error invalid options and found out that in 10g don't have this feature, hence I plan to do online but during off peak hour.
So my question is, when I modify column, if there is insert/update/delete onto the table, would them wait or they will fail?
Please advise.