Normally, the table to be copied does not need to exist in the target database. The table must exist, however, in the target database to copy selected partitions to the table. Additionally, the target table must be a full table, not just selected partitions.
Copying 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. See Restrictions on Archiving Selected Partitions.