Enabling/Disabling Automatic Partitioning

You can run the ALTER statement to enable or disable automatic partitioning for a created partitioned table. This operation holds a SHARE_UPDATE_EXCLUSIVE table lock on the partitioned table. The operation does not affect common DQL/DML services but is mutually exclusive with DDL services. If any DML service triggers automatic partitioning, this operation is also mutually exclusive with the DML service. For details about the behavior control of locks at different levels, see Common Lock Design.

• Enabling/Disabling Automatic Range Partitioning
  
• Enabling/Disabling Automatic Level-1 List Partitioning
  
• Enabling/Disabling Automatic Level-2 List Partitioning