The MANAGE_DYNAMIC_PARTITION system package manages dynamic partitioning tasks, such as precreating future partitions and dropping expired partitions, for dynamic partitioning tables in the current tenant.
Note
For OceanBase Database V4.3.5, the subprogram MANAGE_DYNAMIC_PARTITION 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. Valid values: n {hour \| day \| week \| month \| year}.
|
| time_unit | Optional. Valid values: 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');