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

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.