15.00 - 5740 Column %VSTR is a partitioning column and cannot be altered. - 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)

5740 Column %VSTR is a partitioning column and cannot be altered.

Explanation:

A partitioning column cannot be modified by an ALTER TABLE statement unless the modification does not change the data type, nullability, or name of the column.

Generated By:

OPT modules. DR62813-bessc

For Whom:

End User. DR62813-bessc

Remedy:

If the column needs to be altered, alter the partitioning expression such that the column is not a partitioning column or remove partitioning from the primary index. Then resubmit the ALTER TABLE to alter the column. If desired, the partitioning may then be altered to include the column.