15.00 - Local Journaling - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Local Journaling

The LOCAL single AFTER image journal is supported analogously to a single BEFORE image journal:

  • The access privileges required to create or drop a LOCAL single AFTER image journal are the same as for the analogous operation on a single BEFORE image journal.
  • LOCAL single AFTER image journaling is restricted to non-fallback data tables.
  • Archive/Recovery rules for a single LOCAL AFTER image journal and a single BEFORE image journal are the same, except that LOCAL single AFTER image journal is used with ROLLFORWARD only, while single BEFORE image journal is used with ROLLBACK only.