The MANAGE_DYNAMIC_PARTITION procedure is used to perform a dynamic partition management task, pre-creating future partitions and deleting expired partitions for dynamic partition tables in the current tenant.
Note
For OceanBase Database V4.3.5, the MANAGE_DYNAMIC_PARTITION procedure is supported starting from V4.3.5 BP2.
Syntax
DBMS_PARTITION.MANAGE_DYNAMIC_PARTITION (
precreate_time VARCHAR(64) DEFAULT NULL,
time_unit VARCHAR(64) DEFAULT NULL);
Parameters
Parameter |
Description |
|---|---|
| precreate_time | Optional. n {hour \| day \| week \| month \| year}.
|
| time_unit | Optional. null \| hour \| day \| week \| month \| year.
|
Examples
CALL DBMS_PARTITION.MANAGE_DYNAMIC_PARTITION();
CALL DBMS_PARTITION.MANAGE_DYNAMIC_PARTITION('3DAY');
CALL DBMS_PARTITION.MANAGE_DYNAMIC_PARTITION('3DAY', 'HOUR');