17.10 - Two or More Databases and Users Can Share a Journal Table - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Two or more databases and users can share a journal table. However, if the sharing databases and users retain as their default the name of a journal table that has been dropped from the system, subsequent CREATE TABLE requests that use that default journal abort, and the system return an error message to the requestor.