17.10 - WITH JOURNAL TABLE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

A definition for the permanent journal table for the data table being altered. 
The JOURNAL default for a base data table is determined either by the CREATE TABLE request that created the table or the default fallback specification for the database or user containing the table. You can override these defaults with an ALTER TABLE request.

Journal options are not supported for tables with row sizes greater than 64KB.

table_name
The permanent journal table table_name need not reside in the same database or user as the data table.
 See Teradata Vantage™ - SQL Fundamentals, B035-1141 for the rules for naming database objects.
database_name
The default database for the current session is assumed, unless you specify a database. 
The database must already exist and table_name must have been defined as its default permanent journal table.
user_name
The default database for the current user is assumed, unless you specify a user. 
The user must already exist and table_name must have been defined as its default permanent journal table.