The DBMS_PARTITION system package provides interfaces for dynamic partition management.
Note
For OceanBase Database V4.3.5, the DBMS_PARTITION system package is supported starting from V4.3.5 BP2.
Privileges
Operations can be performed only in user tenants.
Subprogram overview
The following table describes the subprograms of the DBMS_PARTITION package supported in the current version of OceanBase Database and their brief descriptions.
| Subprogram | Description |
|---|---|
| MANAGE_DYNAMIC_PARTITION | Manages dynamic partitions for tables in the current tenant, including precreating future partitions and dropping expired partitions for dynamic partitioned tables. |
