16.20 - WITH JOURNAL TABLE - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

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.