Teradata Database Message 9378 - 17.10 - 9378 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
Operation is not permitted for replication.
Explanation
case(i): When a table in replication group is being altered to add ValidTime or TransactionTime column. The default value for the column must not contain current_date, current_timestamp, temporal_date, temporal_timestamp. case(ii): When DDL capture is enabled, the CREATE TABLE AS <QUERY EXPRESSION> WITH DATA and CREATE TABLE AS <TABLE> WITH DATA is not supported for creating temporal tables.
Generated By
RES/OPU Modules
For Whom
End User.
Notes
None
Remedy
case(i): Provide a period value with literal date or timestamp as default value for ValidTime column.If adding a ValidTime column. None. If adding a TransactionTime column. case(ii): Table must be created using CREATE TABLE followed by an INSERT-SELECT.