Example - Splitting a RANGE Partition v11
This example divides the q4_2012
partition (of the range-partitioned sales
table) into two partitions, and redistribute the partition's contents. Use the following command to create the sales
table:
The table definition creates four partitions (q1_2012, q2_2012, q3_2012
, and q4_2012
). The following command adds rows to each partition.
A SELECT
statement confirms that the rows are distributed amongst the partitions as expected.
The following command splits the q4_2012
partition into two partitions named q4_2012_p1
and q4_2012_p2
.
A SELECT
statement confirms that the rows have been redistributed across the new partitions.