Example: Splitting a LIST partition v16
This example divides one of the partitions in the list-partitioned sales
table into two new partitions and redistributes the contents of the partition between them. The sales
table is created with the statement:
The table definition creates three partitions: europe
, asia
, and americas
. This command adds rows to each partition:
The rows are distributed among the partitions:
This command splits the americas
partition into partitions named us
and canada
:
A SELECT
statement confirms that the rows were redistributed: