Note
- In OceanBase Database V4.2.0 and later, this view is no longer in use because the concept of partition is deprecated in table groups. You can still query this view, but the return result is empty.
- In OceanBase Database V4.2.0 and later, you can query the DBA_OB_TABLEGROUPS view for table groups. For more information about table groups, see Overview.
Purpose
The oceanbase.DBA_OB_TABLEGROUP_PARTITIONS view displays the information about the partitions of partitioned table groups.
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 are YES and NO. |
| PARTITION_NAME | varchar(64) | NO | The name of the 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. Take note of the following points for different partitioning types: LIST or LIST COLUMNS: this value is in a partial ordering relation with the partition creation time.RANGE or RANGE COLUMNS: this value is in a partial ordering relation with HIGH_VALUE.HASH or KEY: PARTITION_POSITION minus 1 indicates the partitioning key value % the number of partitions. |