ALTER TABLE...SET [ PARTITIONING ] AUTOMATIC v17

Use the ALTER TABLE… SET [ PARTITIONING ] AUTOMATIC command to convert an existing list-partitioned table to automatic list partitioning. The database automatically creates a partition based on a new value inserted into a table when AUTOMATIC is set. The syntax is:

ALTER TABLE <table_name> SET [ PARTITIONING ] AUTOMATIC;

To disable AUTOMATIC LIST PARTITIONING and convert to regular LIST partition, the syntax is:

ALTER TABLE <table_name> SET [ PARTITIONING ] MANUAL;

Parameters

table_name

The name (optionally schema-qualified) of the list-partitioned table.

Description

You can use the ALTER TABLE… SET [ PARTITIONING ] AUTOMATIC command to convert the regular list-partitioned table to use automatic partitioning. A partition is created, and you can insert data into the new partition.

You can use the ALTER TABLE… SET [ PARTITIONING ] MANUAL command to disable the automatic list partitioning. The database converts an automatic list-partitioned table to a regular list-partitioned table.