Partition Schemes Available for Splitting or Merging

alter table allows you to split, merge, or move range and list partitioning schemes.

Because the location for the data in round-robin partitioned tables is distributed randomly among the data partitions, there is no need to split or merge round-robin partitions.

For hash-partitioned tables, use the repartition utility to redistribute the data.