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.
- 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.
- 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.
- 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.