multi value compression

Database
Highlighted
Enthusiast

multi value compression

Hi all,

Is there any one who can tell that multi value compression can be implement in existing table ???

Regards,
gander_ss

1 REPLY 1
SN
Enthusiast

Re: multi value compression

hi,

you can add a new column with multi valued compression to an existing table, but cannot modify an existing compressed column.
Instead, you can either create a new table with the column designated for multivalued compression and INSERT … SELECT data into it from the existing table or you can use CREATE TABLE … AS with the target column designated
for multivalued compression.

thx