WITH JOURNAL TABLE - Advanced SQL Engine - Teradata Database

This clause is required if the CREATE TABLE statement specifies some level of journaling, but a default journal table was not defined for the database in which the new table is being created.

If you specify permanent journaling for this table, but do not specify a journal table with this clause, then you must define a default permanent journal table for the containing database.

If a default permanent journal table was defined for the database, then this clause can be used to override the default.

You cannot add or modify journal options for a NoPI table or for a column-partitioned table.

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

table_name

The name of the permanent journal table to be used for the data table being created.

table_name can be contained within the same database as the table being created or in a different database.

database_name

If you specify a database name, then that name must exist and table_name must have been defined as its default permanent journal name.

If you do not specify a database name, then the default database for the current session is assumed and table_name must have been defined as the default permanent journal table.

user_name

If you specify a user name, then that name must exist and table_name must have been defined as its default permanent journal name.

If you do not specify a user name, then the default user for the current session is assumed and table_name must have been defined as the default permanent journal table.