15.10 - WITH JOURNAL TABLE - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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

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.

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.