All Forums General
knip 2 posts Joined 03/11
13 Aug 2012
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       ')

ulrich 816 posts Joined 09/09
13 Aug 2012

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...

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

You must sign in to leave a comment.