Note
- Starting from V4.2.0, table groups no longer have partitions. This view is therefore no longer used. You can query this view, but the query result is empty.
- For V4.2.0 and later, you can query information about table groups by using the view DBA_OB_TABLEGROUPS. For more information about table groups, see About table groups.
Purpose
This view displays the subpartitions of partitions in table groups.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLEGROUP_NAME | varchar(128) | NO | The name of the table group. |
| PARTITION_NAME | varchar(64) | NO | The name of the primary partition corresponding to the subpartition in the table group. |
| SUBPARTITION_NAME | varchar(64) | NO | The name of the subpartition in the table group. |
| 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. |
| SUBPARTITION_POSITION | bigint(20) unsigned | NO | The value is NULL. |