The following options restore partitioned data:
- PARTITIONS WHERE specifies the conditional expression that determines which rows to restore to the table. Use this option only if the following conditions are true:
- The object is an individual table rather than a database.
- The source and target tables have a defined PARTITIONS BY expression.
- The restore is an all-AMP restore.
- The table is excluded from the database object (via EXCLUDE TABLES) if the table belongs to a database object that is specified in the RESTORE script.
- LOG WHERE conditionally inserts (log) archived rows that fall outside the partitions specified by the PARTITIONS WHERE conditional expression into a Teradata-generated error table. Teradata ARC inserts into the error table any rows that match the LOG WHERE conditional expression and fall outside the partitions specified by the PARTITIONS WHERE conditional expression.