ALTER TABLE...MOVE PARTITION v16
Use the ALTER TABLE… MOVE PARTITION
command to move a partition to a different tablespace. The command takes two forms.
The first form moves a partition to a new tablespace:
The second form moves a subpartition to a new tablespace:
Description
The ALTER TABLE…MOVE PARTITION
command moves a partition from its current tablespace to a different tablespace. The ALTER TABLE… MOVE PARTITION
command can move partitions of a LIST
, RANGE
or HASH
partitioned table.
The same behavior applies for the subpartition_name
used with the MOVE SUBPARTITION
clause.
You must own the table to invoke ALTER TABLE… MOVE PARTITION
or ALTER TABLE… MOVE SUBPARTITION
.
Parameters
table_name
The name (optionally schema-qualified) of the table in which the partition or subpartition resides.
partition_name
The name of the partition to move.
subpartition_name
The name of the subpartition to move.
tablespace_name
The name of the tablespace to which the partition or subpartition is moved.
example_moving_a_partition_to_a_different_tablespace
- On this page
- Description
- Parameters