Note
This view is introduced in V4.3.5 BP2.
Purpose
This view displays the information about dynamic partitioned tables for all tenants. This view is accessible only to the system tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID where the dynamic partitioned table is located. |
| DATABASE_NAME | varchar(128) | NO | The name of the database where the dynamic partitioned table resides. |
| TABLE_NAME | varchar(256) | NO | The name of the dynamic partitioned table. |
| TABLE_ID | bigint(20) | NO | The ID of the dynamic partitioned table. |
| MAX_HIGH_BOUND_VAL | varchar(4096) | NO | The maximum range partition upper bound. |
| ENABLE | varchar(4096) | NO | Whether dynamic partition management is enabled. |
| TIME_UNIT | varchar(4096) | NO | The value of time_unit in dynamic partition management. |
| PRECREATE_TIME | varchar(4096) | NO | The value of precreate_time in dynamic partition management. |
| EXPIRE_TIME | varchar(4096) | NO | The value of expire_time in dynamic partition management. |
| TIME_ZONE | varchar(4096) | NO | The value of time_zone in dynamic partition management. |
| BIGINT_PRECISION | varchar(4096) | NO | The value of bigint_precision in dynamic partition management. |
Sample query
SELECT * FROM oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES LIMIT 1\G
The query result is as follows:
*************************** 1. row ***************************
DATABASE_NAME: db_test
TABLE_NAME: tbl2
TABLE_ID: 502062
MAX_HIGH_BOUND_VAL: '2025-04-15 14:00:00'
ENABLE: TRUE
TIME_UNIT: HOUR
PRECREATE_TIME: 3HOUR
EXPIRE_TIME: 1DAY
TIME_ZONE: +8:00
BIGINT_PRECISION: NONE
1 row in set