Purpose
The DBA_OB_TABLEGROUPS view displays the metadata of a table group, mainly the partition information of the table group.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLEGROUP_NAME | VARCHAR2(128) | NO | The name of the table group. |
| PARTITIONING_TYPE | VARCHAR2(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 |
| SUBPARTITIONING_TYPE | VARCHAR2(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 |
| PARTITION_COUNT | NUMBER | NO | The number of partitions in the partitioned table group. For a non-partitioned table group, the value is NULL. |
| DEF_SUBPARTITION_COUNT | NUMBER | NO | The number of subpartitions in the partitioned table group. For a non-subpartitioned table group, the value is NULL. |
| PARTITIONING_KEY_COUNT | NUMBER | NO | The number of partitioning keys for the partitioned table group. For a non-partitioned table group, the value is NULL. |
| SUBPARTITIONING_KEY_COUNT | NUMBER | NO | The number of subpartitioning keys for the partitioned table group. For a non-subpartitioned table group, the value is NULL. |