Teradata Database Message 9327 - 9327 - Analytics Database - Teradata Vantage

Analytics Database Messages

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
15.xx,16.xx,17.xx
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-01-05
dita:mapPath
sfx1628096178347.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-1096
lifecycle
latest
Product Category
Teradata Vantageā„¢
Message
An existing column can not be altered to be a temporal column.
Explanation
One of the existing columns is defined as a temporal column in the ALTER TABLE statement. An ALTER TABLE statement does not permit an existing column to be made into a temporal column.
Generated By
OPD Modules
For Whom
End User.
Notes
None
Remedy
Add a new column as a temporal column and drop the existing column once the data is processed into the new temporal column.