Hash Partitioning Redefinition

Description

You can redefine a partition by using the COALESCE PARTITION clause of the ALTER statement. Instances are preserved if the hash partition is redefined.

Syntax

ALTER {TABLE | CLASS} <table_name>
COALESCE PARTITION <unsigned integer>

Example

The following example shows how to decrease the number of partitions in the nation2 table from 4 to 2.

ALTER TABLE nation2 COALESCE PARTITION 2;

Caution