Note
- This view is available starting with V4.4.0 for V4.4.x.
- This view is available starting with V4.3.5 BP2 for V4.3.5.
Purpose
This view displays the information about dynamic partition tables of all tenants and is accessible only to the sys tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant where the dynamic partition table resides. |
| DATABASE_NAME | varchar(128) | NO | The name of the database where the dynamic partition table resides. |
| TABLE_NAME | varchar(256) | NO | The name of the dynamic partition table. |
| TABLE_ID | bigint(20) | NO | The ID of the dynamic partition table. |
| MAX_HIGH_BOUND_VAL | varchar(4096) | NO | The upper bound of the maximum range partition. |
| ENABLE | varchar(4096) | NO | Indicates whether dynamic partition management is enabled. |
| TIME_UNIT | varchar(4096) | NO | The time_unit parameter for dynamic partition management. |
| PRECREATE_TIME | varchar(4096) | NO | The precreate_time parameter for dynamic partition management. |
| EXPIRE_TIME | varchar(4096) | NO | The expire_time parameter for dynamic partition management. |
| TIME_ZONE | varchar(4096) | NO | The time_zone parameter for dynamic partition management. |
| BIGINT_PRECISION | varchar(4096) | NO | The bigint_precision parameter for dynamic partition management. |
Sample query
Query the information about a dynamic partition table.
obclient> SELECT * FROM oceanbase.CDB_OB_DYNAMIC_PARTITION_TABLES LIMIT 1\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1002
DATABASE_NAME: db_test
TABLE_NAME: tbl2
TABLE_ID: 502062
MAX_HIGH_BOUND_VAL: '2024-11-11 13:30:00'
ENABLE: TRUE
TIME_UNIT: HOUR
PRECREATE_TIME: 3HOUR
EXPIRE_TIME: 1DAY
TIME_ZONE: +8:00
BIGINT_PRECISION: NONE
1 row in set