Automatic Partitioning

The automatic partitioning function is an enhanced capability of the partitioned table. If new data of DML services (such as INSERT, UPDATE, UPSERT, MERGE INTO, and COPY) cannot match any existing partition, a partition is automatically created. In addition, when a sparsely partitioned index is created using PARTITION/SUBPARTITION for partition_value, if the specified partition does not exist, a partition is automatically created. Currently, automatic range/list partitioning is supported.

• Automatic Range Partitioning
  
• Automatic List Partitioning
  
• Enabling/Disabling Automatic Partitioning
  
• Automatic Partitioning Policy