WITH JOURNAL TABLE - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™

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.