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
ft:locale
en-US
ft:lastEdition
2024-12-13
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jbg1472252759029
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.