DDL operations on partitions

You can drop, rename, partition, unpartition, merge, split, and move table partitions, with the following restrictions:

Operation

Restriction

Drop

You cannot drop a partition key column or the last partition of a partitioned table.

Rename

N/A

Partition an unpartitioned table

N/A

Merge two adjacent partitions

Both partitions must reside in the same dbspace. No data movement is required.

Split a partition

All rows must belong to one of the two partitions after splitting. Split partition must be on same dbspace as original so that no data movement is required.

Move a partition to a new dbspace.

All rows of the partition are moved to data pages in the new dbspace. CREATE permission in the new dbspace is required.

Partitioned tables cannot participate in a join index.