Restoring Archived Partitions

You can restore partitions that you previously moved to an intermediate table, archived as an object-level backup, and then dropped.

Note: Restoring an archived partition requires that the original table definition has not changed since the partition was archived and dropped. If you have changed the table definition, you can only restore an archived partition using INSERT/SELECT statements, which are not described here.

These are the steps to restoring archived partitions:

  1. Restore the backup of the intermediate table you saved when you moved one or more partitions to archive (see Archiving Partitions).
  2. Move the restored partitions from the intermediate table to the original table.
  3. Drop the intermediate table.