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

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.