Data Protection Methods | CREATE TABLE | Teradata Vantage - Specifying Data Protection - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

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
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

Specific protection for the data in a table is provided by the FALLBACK, JOURNAL, and CHECKSUM options.

FALLBACK causes a duplicate, or fallback, copy to be maintained by Vantage. The fallback copy is used if the primary copy becomes unavailable.

JOURNAL provides data protection through system-generated BEFORE- and AFTER-journals that contain the before and after images of data that changes as a result of any INSERT, UPDATE, or DELETE operations.

These journals are used by the database either to restore a table or to roll back the changes that were made to a table.

The CHECKSUM option provides disk I/O integrity checking of primary table data rows, fallback table data rows, and secondary index subtable rows.