15.00 - 9454 Compress Attribute cannot be changed on column '%VSTR' when table has data. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

9454 Compress Attribute cannot be changed on column '%VSTR' when table has data.

Explanation:

ALTER TABLE cannot change the compress attribute on a column that has data. This is when either the old or new compress attribute has ALC.

Generated By:

RES.

For Whom:

End User.

Remedy:

Take a backup of data, delete it, change the compression attribute, and reload the data.