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 DBA_OB_TABLEGROUP_PARTITIONS view displays the information about the partitions of partitioned table groups.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLEGROUP_NAME | VARCHAR2(128) | NO | The name of the table group. |
| COMPOSITE | VARCHAR2(3) | NO | Indicates whether the table group is subpartitioned. Valid values are YES and NO. |
| PARTITION_NAME | VARCHAR2(64) | NO | The name of the partition of the partitioned table group. |
| SUBPARTITION_COUNT | NUMBER | NO | The value of this column is NULL. |
| HIGH_VALUE | VARCHAR2(4096) | NO | The value of this column is NULL. |
| HIGH_VALUE_LENGTH | NUMBER | NO | The value of this column is NULL. |
| PARTITION_POSITION | NUMBER | NO | The value of this column is NULL. |