15.00 - 9326 Cannot add TransactionTime column to the table: %VSTR. - 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)

9326 Cannot add TransactionTime column to the table: %VSTR.

Explanation:

A table with a join index and/or a trigger defined on it or if it is a temporal table with uinque or primary key constraints that requires system-defined JI then table cannot be altered to add a TransactionTime column.

Generated By:

RES Modules

For Whom:

End User.

Remedy:

Drop any join indexes and/or triggers or unique or primary constraints that requires sytem-defined JI(if the table being altered is a temporal table) and resubmit the request. Recreate the droped join indexes and/or triggers or unique or primary key constraints once the table is altered.