17.10 - Local Journaling - 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)
LOCAL single AFTER image journals are supported analogously to single BEFORE image journals as follows:
  • The DROP DATABASE privilege is required to create or drop LOCAL single AFTER image journals. This is the same privilege required to perform the analogous operation on single BEFORE image journals.
  • LOCAL single AFTER image journaling is restricted to non-fallback data tables.

MultiLoad, Teradata Parallel Transporter, and FastLoad are impacted by the use of LOCAL journaling.