Coalescing a Partition in a Hash Partitioned Table
The ALTERTABLECOALESCEPARTITION statement is used to coalesce a partition in a hash partitioned table. The following statement reduces by one the number of partitions in a table by coalescing a partition.