Modifying a column from varchar2(11) to varchar2(15)
536042Jan 25 2009 — edited Jan 25 2009Hello,
I have a 600 GB table containing nearly 200 columns. This table is obviously not truncated plus it is a partitioned and subpartitioned table. I have a varchar2 column which length I need to increase. This table is on a production database and therefore I MUST run no big risks with it even though I have to figure out a way to increase the concerned column's size. Let's say the table name is XLARGE_TABLE and the Column I need to alter is called FIRST_COLUMN. I'd like to know of the safety and run time of running the simple following ALTER statement:
ALTER TABLE XLARGE_TABLE MODIFY FIRST_COLUMN varchar2(15).
NOTE: FIRST_COLUMN is populated in all of the table's millions of rows.
Thanks a lot for your attention to help me on this matter.
T. San.