The DBMS_PARTITION system package provides interfaces for dynamic partition management.
Note
For OceanBase Database V4.3.5, the DBMS_PARTITION package is supported starting from V4.3.5 BP2.
Privileges
Operations can be performed only in user tenants.
Subprogram overview
The following table lists the DBMS_PARTITION subprograms supported by the current version of OceanBase Database and provides a brief description.
| Subprogram | Description |
|---|---|
| MANAGE_DYNAMIC_PARTITION | Performs a dynamic partition management task: pre-create future partitions and delete expired partitions for dynamic partition tables under the current tenant. |