Note
- The concept of partitions no longer exists for table groups. This view is no longer used. Users can query it, but the result will be empty.
- You can query table group information through the DBA_OB_TABLEGROUPS view. For more details about table groups, see About table groups.
Overview
Displays the subpartition information for a table group with partitions.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| TABLEGROUP_NAME | varchar(128) | NO | TABLEGROUP Name |
| PARTITION_NAME | varchar(64) | NO | The name of the partition to which the subpartition belongs. |
| SUBPARTITION_NAME | varchar(64) | NO | Subpartition name of 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 | This value is NULL. |