PARTITION WHERE is the option that specifies the conditional expression for selecting partitions. If the condition selects a partial partition, the entire partition is archived.
We need to consider the following when archiving the partition table using ARCHIVE:
- A restore operation always deletes the selected partitions of the target table before restoring the rows that are stored in the archive
- Use the EXCLUDE TABLES option to manage both PPI and non-PPI tables in a single command
- Locks are placed on the table and not on the partition getting archived
- Statistics on the table need to be re-collected after the table has been restored
- A change in table definition will make the restore fail