Oracle Database Merge Partitions


Example

Merge two partitions into single one

ALTER TABLE table_name
  MERGE PARTITIONS first_partition, second_partition
  INTO  PARTITION  splitted_partition TABLESPACE new_tablespace