Restoring from a Dictionary Archive - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
utr1488824663491.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
lifecycle
previous
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.

User Database Data Dictionary Rows Restored 
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.

User Table Dictionary Rows Restored 
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