ADD PARTITION

You can add partitions to an existing partitioned table to maintain new services. Currently, a partitioned table can contain a maximum of 1048575 partitions. If the number of partitions reaches the upper limit, no more partitions can be added. In addition, the memory usage of partitions must be considered. Typically, the memory usage of a partitioned table is about (Number of partitions x 3/1024) MB. The memory usage of a partition cannot be greater than the value of local_syscache_threshold. In addition, some space must be reserved for other functions.

• This command cannot be applied to hash partitions.
• New partitions do not inherit the sparsely partitioned index attribute of the table.

• Adding a Partition to a Range Partitioned Table
  
• Adding a Partition to an Interval Partitioned Table
  
• Adding a Partition to a List Partitioned Table
  
• Adding a Partition to a Level-2 Partitioned Table
  
• Adding a Level-2 Partition to a Level-2 Partitioned Table