Restrictions on Copying Partitioned Data - 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

Normally, the table to be copied does not need to exist in the target database. The table must exist, however, in the target database to copy selected partitions to the table. Additionally, the target table must be a full table, not just selected partitions.

Copying selected partitions is not allowed to a table that has undergone any of the following major DDL changes:

  • Changing primary index columns
  • Changing from PPI to NPPI, or visa versa
  • Adding or changing referential integrity constraints

Other restrictions exist for archiving selected partitions. See Restrictions on Archiving Selected Partitions.