The MANAGE_DYNAMIC_PARTITION statement is used to perform a one-time dynamic partition management task, which includes pre-creating future partitions and dropping expired partitions for dynamic partitioned tables under the current tenant.
Syntax
DBMS_PARTITION.MANAGE_DYNAMIC_PARTITION (
precreate_time VARCHAR(64) DEFAULT NULL,
time_unit VARCHAR(64) DEFAULT NULL);
Parameters
Parameter |
Description |
|---|---|
| precreate_time | Optional value. n {hour \| day \| week \| month \| year}.
|
| time_unit | Optional value. 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');