Purpose
The oceanbase.DBA_OB_TABLEGROUPS view displays the metadata of a table group, mainly the partition information about the 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. |
| PARTITIONING_TYPE | varchar(13) | NO | The partitioning type of the partitioned table group. Valid values: NONE: non-partitioningHASH: HASH partitioning (with a single partitioning key)KEY: KEY partitioningRANGE: RANGE partitioning (with a single partitioning key)RANGE COLUMNS: RANGE COLUMNS partitioningLIST: LIST partitioning (with a single partitioning key)LIST COLUMNS: LIST COLUMNS partitioningUNKNOWN: an unknown type
NoteThis column is introduced since OceanBase Database V4.2.0 and is |
| SUBPARTITIONING_TYPE | varchar(13) | NO | The subpartitioning type of the partitioned table group. Valid values: NONE: non-subpartitioningHASH: HASH partitioning (with a single partitioning key)KEY: KEY partitioningRANGE: RANGE partitioning (with a single partitioning key)RANGE COLUMNS: RANGE COLUMNS partitioningLIST: LIST partitioning (with a single partitioning key)LIST COLUMNS: LIST COLUMNS partitioningUNKNOWN: an unknown type
NoteThis column is introduced since OceanBase Database V4.2.0 and is |
| PARTITION_COUNT | bigint(20) | NO | The number of partitions in the partitioned table group. For a non-partitioned table group, the value is NULL. |
| DEF_SUBPARTITION_COUNT | bigint(0) | NO | The number of subpartitions in the partitioned table group. For a non-subpartitioned table group, the value is NULL. |
| PARTITIONING_KEY_COUNT | bigint(20) | NO | The number of partitioning keys for the partitioned table group. For a non-partitioned table group, the value is NULL. |
| SUBPARTITIONING_KEY_COUNT | bigint(20) | NO | The number of subpartitioning keys for the partitioned table group. For a non-subpartitioned table group, the value is NULL. |
