Note
- Starting from V4.2.0, table groups no longer have the concept of partitions. Therefore, this view is no longer in use. Users 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 DBA_OB_TABLEGROUPS view. For more information about table groups, see About table groups.
Purpose
This view displays information about subpartitions of a partitioned table group.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLEGROUP_NAME | VARCHAR2(128) | NO | Name of the table group. |
| PARTITION_NAME | VARCHAR2(64) | NO | Name of the primary partition corresponding to the subpartition. |
| SUBPARTITION_NAME | VARCHAR2(64) | NO | Name of the subpartition. |
| HIGH_VALUE | VARCHAR2(4096) | NO | Value of NULL. |
| HIGH_VALUE_LENGTH | NUMBER | NO | Value of NULL. |
| PARTITION_POSITION | NUMBER | NO | Value of NULL. |
| SUBPARTITION_POSITION | NUMBER | NO | Value of NULL. |