ALL PARTITIONS Keyword - 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

Use the ALL PARTITIONS option to copy all of the archived partitions in a table. These restrictions apply:

  • The object being copied is an individual table, or the ALL FROM ARCHIVE option is specified.
  • The source and target tables have a PARTITIONS BY expression defined.
  • The copy is an all-AMP copy rather than a dictionary, cluster, or journal copy.
  • PARTITIONS WHERE is not specified for the object.
  • The partition bounding condition must have been well-defined when the backup was performed. A bounding condition is well-defined if the PARTITION BY expression on the source table consists of a single RANGE_N function, and if the specified range does not include NO RANGE or UNKNOWN. Use ANALYZE to determine whether a selected partition is well-defined.

    If a conditional expression is not well-defined, Teradata ARC issues an error. Use PARTITIONS WHERE for the restore operation rather than ALL PARTITIONS.