Restoring from a Dictionary Archive - Teradata Tools and Utilities

Teradata® Archive/Recovery Utility Reference

Product
Teradata Tools and Utilities
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-06-05
dita:mapPath
fac1527114221922.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
Product Category
Teradata Tools and Utilities

If a database from a dictionary archive created by specifying individual tables is restored, only the dictionary rows for the specified tables are restored. The following table alphabetically lists the dictionary rows that are restored by an all-AMPs data restore or a dictionary tables restore of a user database.

Table Rows Description
Indexes Definition of all indexed columns for all objects in the database
IndexName Definition of named indexes in the table
TVM Definition of all objects in the database
TVFields Definition of all columns for all objects in the database
TriggersTbl Definition of all triggers in the database

This table lists the dictionary table rows that are restored by an all-AMPs restore of a specific user data table or journal table.

Tables Rows Description
Indexes Columns in tables that are indexes
IndexName Indexes in the table that have names
TVM Table names
TVFields Columns for the table