Note
- Because partitions no longer exist for table groups, this view is deprecated. 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 of a table group that is partitioned.
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 | This value is NULL |
| PARTITION_POSITION | bigint(20) unsigned | NO | The value is NULL |
| SUBPARTITION_POSITION | bigint(20) unsigned | NO | This value is NULL. |