15.00 - Providing for a Permanent Journal - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

Providing for a Permanent Journal

A permanent journal table is created and activated when the default JOURNAL table option and a journal table name are specified as part of the CREATE/MODIFY DATABASE/USER request (see “CREATE DATABASE” on page 225, “CREATE USER” on page 769, “MODIFY DATABASE” on page 827, and “MODIFY USER” on page 831). The specified table resides in the database or user space that defined it. In addition, the specified JOURNAL parameters serve as the defaults for all the data tables created in that database or user space.

In defining a new table, you can override the established permanent journaling defaults by specifying the JOURNAL options as part of the CREATE TABLE request. Thus you can specify the journal table, the type of image (before-change, after-change, or both) and whether dual images are to be maintained for the created table, no matter the option established when the containing database or user was created.

Whenever the structure of a table is altered, its version number increments. The following primary index changes qualify as changes to table structure.

  • Modification to its partitioning, including revalidation
  • Modification to its uniqueness
  • Modification to its column set definition
  • As a result of changing the version number for a table, permanent journal rollforward and rollback operations from previous table versions are no longer valid.

    You can activate permanent journaling for existing tables using the ALTER TABLE statement (see “ALTER TABLE (Basic Table Parameters)” on page 31, particularly “Activating Permanent Journaling” on page 43).

    Permanent journals are not supported for unpartitioned NoPI, column‑partitioned, global temporary, or volatile tables.