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.