Copy - 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

Use CATALOG in a copy operation only to selectively copy one or some databases or tables. If most or all of a tape is being copied, do not use CATALOG.

Copy operations to the same system from which data was archived work similarly to restore operations with respect to the use of catalog information. To use CATALOG in a copy operation to a different system, knowing the UEN of the tape is necessary. Obtain the UEN by using an ANALYZE statement or by reading the output from an ARCHIVE statement. Use the UEN to archive and copy the corresponding CATALOG table from the source system to the target system before running a copy operation.