Alter a table

General
Fan

Alter a table

Hi Experts,

                    I need to alter data type of  a column with out losing data in the table, how can i achieve this?

   initially it is  COL_A CHAR(8) CHARACTER SET LATIN CASESPECIFIC NOT NULL COMPRESS ('1       ','2       ')

 now it should be  COL_A CHAR(8) CHARACTER SET LATIN CASESPECIFIC NOT NULL COMPRESS ('1       ','2       ','3       ')

1 REPLY
Supporter

Re: Alter a table

seems you don't want to change the data type but to update your compression list, correct?

Alter table_x

add col_a char(8) COMPRESS ('1       ','2       ','3       ');

Just try it on a test table...