Updated on 2024-06-07 GMT+08:00

SPLIT PARTITION

You can run this command to split a partition into two or more partitions. This operation is considered when the partition data is too large or you need to add a partition to a range partition with MAXVALUE or a list partition with DEFAULT. You can specify a split point to split a partition into two partitions, or split a partition into multiple partitions without specifying a split point. You can split a partition by specifying the partition name or partition value.

  • This command cannot be applied to hash partitions.
  • Partitions in a level-2 partitioned table cannot be split.
  • Running this command will invalidate the global index. You can use the UPDATE GLOBAL INDEX clause to update the global index synchronously or rebuild the global index.
  • If the target partition contains a sparsely partitioned index, the partition cannot be split.
  • The names of the new partitions can be the same as that of the source partition. For example, partition p1 is split into p1 and p2. However, the database does not consider the partitions with the same name before and after the splitting as the same partition, which affects the query of the source partition p1 during the splitting. For details, see DQL/DML-DDL Concurrency.