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

A dictionary only archive just archives the Teradata Database dictionary rows that are needed to define a database or table. No table data is archived. When using the multi-stream feature, a dictionary archive must be run as a single-stream job.

Examples

LOGON USER,PASSWORD;
ARCHIVE DICTIONARY TABLES (USERDB), FILE=DBDICT;
LOGOFF;

LOGON USER,PASSWORD;
ARCHIVE DICTIONARY TABLES (USERDB.USERTB), FILE=TBDICT;
LOGOFF;