Use the PARTITIONS WHERE option to specify the conditional expression for selected partitions. The expression must contain the definition of the partitions that will be copied. The following restrictions apply to the use of PARTITIONS WHERE:
- The object is an individual table (not a database).
- The source and target tables have a PARTITIONS BY expression defined.
- The copy is an all-AMP copy (not a dictionary, cluster, or journal copy).
- If the table belongs to a database that is specified in COPY, the table is excluded from the database-level object (with EXCLUDE TABLES) and is individually specified.
- Any name specified in the conditional expression is within the table being specified. (Using table aliases and references to databases, tables, or views that are not specified within the target table result in an error.) It is recommended that the only referenced columns in the conditional expression be the partitioning columns or system-derived column PARTITION of the table. References to other columns does not contribute to partition elimination, and might accidentally qualify more partitions than intended.