Before attempting to restore selected partitions, read Potential Data Risks When Archiving/Restoring Selected Partitions and Changes Allowed to a PPI Table.
The following restrictions apply to restoring selected partitions:
- Restoring selected partitions is not allowed to a machine with a hash function that is different from the source machine, but a different configuration is allowed.
- To restore or copy selected partitions, a table must already exist on the target system. For a copy, the existing table must have been created by a full-table copy from the source machine.
- Restoring selected partitions is not allowed to a table that has undergone any of the following major DDL changes:
- Adding, modifying, or dropping columns.
- Certain changes during RESTORE and COPY operations. See Restrictions on Copying Partitioned Data.
Restoring selected partitions is not allowed to a table that has undergone any of the following major DDL changes:
- Changing primary index columns
- Changing from PPI to NPPI, or visa versa
- Adding or changing referential integrity constraints
Other restrictions exist for archiving selected partitions of PPI tables. See Restrictions on Archiving Selected Partitions.