Purpose
The oceanbase.DBA_OB_TABLEGROUP_PARTITIONS view provides information about the partitions of a partitioned table group.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| TABLEGROUP_NAME | varchar(128) | NO | The name of the table group. |
| COMPOSITE | varchar(3) | NO | Indicates whether the table group is subpartitioned. Valid values: YES and NO. |
| PARTITION_NAME | varchar(64) | NO | The name of a partition of the partitioned table group. |
| SUBPARTITION_COUNT | bigint(20) | NO | The number of subpartitions in the partitions of the partitioned table group. For a non-subpartitioned table group, the value is NULL. |
| HIGH_VALUE | varchar(4096) | NO | The partitioning key value for the partitioned table group. For a HASH- or KEY-partitioned table group, the value is NULL. |
| HIGH_VALUE_LENGTH | bigint(20) | NO | The character length of the partitioning key value when HIGH_VALUE is valid. |
| PARTITION_POSITION | bigint(20) unsigned | NO | The partition number of the table group, which starts from 1. HIGH_VALUE.PARTITION_POSITION - 1 indicates the partitioning key value % the number of partitions. |