Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

12.11 ALTER TABLE… MOVE PARTITION

Use the ALTER TABLEMOVE PARTITION command to move a partition to a different tablespace. Two forms of the command are supported; the syntax is:

      ALTER TABLE table_name
      MOVE PARTITION partition_name
      TABLESPACE tablespace_name;

      and

      ALTER TABLE table_name
      MOVE SUBPARTITION partition_name
      TABLESPACE tablespace_name;

Description

This command makes no distinctions between a partition and a subpartition:

    ● You can move a partition with the MOVE PARTITION or MOVE SUBPARTITION clause.

    ● You can move a subpartition with MOVE PARTITION or MOVE SUBPARTITION clause.

You must own a table to invoke ALTER TABLEMOVE PARTITION or ALTER TABLE MOVE SUBPARTITION against that table.

Parameters

table_name

The name (optionally schema-qualified) of the table in which the partition resides.

partition_name

The name of the partition or subpartition to be renamed.

tablespace_name

The name of the tablespace to which the partition or subpartition will be moved.

Example

The following command moves the 4th_quarter partition of the sales table into a tablespace named active_sales:

      ALTER TABLE sales
      MOVE PARTITION 4th_quarter
      TABLESPACE active_sales;

Previous PageTable Of ContentsNext Page