Note
- Since V4.2.0, table groups no longer have partitions. This view is no longer used, but you can still query it, and the query result will be empty.
- For V4.2.0 and later, you can query table group information by using the DBA_OB_TABLEGROUPS view. For more information about table groups, see Table groups.
Purpose
This view displays the partition information of a table group.
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 a composite partition. Valid values: YES and NO. |
| PARTITION_NAME | varchar(64) | NO | The name of the partition of the table group. |
| SUBPARTITION_COUNT | bigint(20) | NO | The value is NULL. |
| HIGH_VALUE | varchar(4096) | NO | The value is NULL. |
| HIGH_VALUE_LENGTH | bigint(20) | NO | The value is NULL. |
| PARTITION_POSITION | bigint(20) unsigned | NO | The value is NULL. |