The MANAGE_DYNAMIC_PARTITION procedure is used to perform a dynamic partition management task for the current tenant, pre-creating future partitions and deleting expired partitions for dynamic partition tables.
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 VARCHAR2 DEFAULT NULL,
time_unit VARCHAR2 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');