Background
Range partitioning: Multiple rows with column values in an ordered, continuous, and non-overlapping range are assigned to a partition. For details, see Set partitioning rules.
Partitioning Plan: When inserting data in a range-partitioned table, if the inserted data exceeds the upper limit value of the current partition table, the data will not be inserted and an error will be returned. Partitioning plan is an extension function specially for range partitioning. ODC supports automatic management of range-partitioned table according to the partitioning strategy set by the user. Users do not need to manually create new partitions to facilitate the maintenance of range-partitioned table.
Create a partitioning plan
Log on to the ODC console, and click the name of the target connection to go to the corresponding database object management page.
In the top navigation pane, choose Tool > Partition Plan to display the Create a partition plan panel.
In the Create a partition plan panel, specify the following information.
Parameter
Description
Connection
The connection to which the partitioning plan belongs. The default value is the current connection.
Partition policy
The information about the partitioning strategy. Search for and select a RANGE-partitioned table in the database and edit its partitioning strategy.
You can select Only tables that are not set are displayed on the right side of Partition policy to display only tables with no partitioning strategies.
You can also select multiple RANGE-partitioned tables and configure a partitioning strategy for them at a time.
In the Partition policy column, click the edit icon and then you can edit the number of partitions to create, partitioning interval, retention period, and naming rules.
Number of Partitions: set the number of partitions to pre-create.
Partition Interval: pre-create the corresponding number of partitions based on the time interval, unit: day/month/year.
Retention Period: the created partition is automatically cleared after the retention period expires, unit: day/month/year.
Example: The number of partitions is 1, the partition interval is 1 month, and the retention period is 1 month, which means that 1 partition is pre-created for the current table, and 1 partition will be created every 1 month, and the created partition will be cleaned up automatically after 1 month.
Remarks
The business background of the project, such as the change purposes and expected goals.
After you specify the preceding information, click Submit in the lower-right corner of the panel.
After the task is generated, the Task Center panel automatically appears, where you can view the task status and task information. For more information, see Partitioning plan tasks.
