Copying a Data Table to a New Database - 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

In this example, an archived data table is copied under a new database name to a different Teradata Database:

COPY DATA TABLE (Personnel.Department)
   (FROM (OldPersonnel), NO JOURNAL, NO FALLBACK)
   ,FILE = ARCHIVE;
In this example:
  • The new database name is Personnel; the old database name is OldPersonnel. In both databases, the table name is Department.
  • If a database named Personnel does not exist in the target system, Teradata ARC rejects the copy operation.
  • If a data table named Department does not exist in the Personnel database on the target system, Teradata ARC creates one with that name.
  • The NO JOURNAL option indicates that this table should not have permanent journaling in the target database.
  • The NO FALLBACK option indicates that the new table should be nonfallback on the target system, even if it was a fallback table on the archived system.