Adding Compression to existing table

Database
Not applicable

Re: Adding Compression to existing table

And if you want to add more values to the existing Compression List, you can do it as under :

ALTER TABLE DBA_TEST_DB.TEST_COMPRESSION

ADD  column_b DECIMAL(15,2) COMPRESS ( 0.00, 0.20 )

,ADD column_C DECIMAL(15,2) COMPRESS (0.00, 0.30 );

=> remember to include the existing values also with this command else they will be overwritten with new values.

--Cheers