Note
- In OceanBase Database V4.2.0 and later, this view is no longer in use because the concept of partition is deprecated in table groups. You can still query this view, but the return result is empty.
- In OceanBase Database V4.2.0 and later, you can query the DBA_OB_TABLEGROUPS view for table groups. For more information about table groups, see Overview.
Purpose
The DBA_OB_TABLEGROUP_SUBPARTITIONS view displays the information about the subpartitions of partitioned table groups.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLEGROUP_NAME | VARCHAR2(128) | NO | The name of the table group. |
| PARTITION_NAME | VARCHAR2(64) | NO | The name of the partition corresponding to the subpartition of the table group. |
| SUBPARTITION_NAME | VARCHAR2(64) | NO | The name of the subpartition of the table group. |
| HIGH_VALUE | VARCHAR2(4096) | NO | The value of this column is NULL. |
| HIGH_VALUE_LENGTH | NUMBER | NO | The value of this column is NULL. |
| PARTITION_POSITION | NUMBER | NO | The value of this column is NULL. |
| SUBPARTITION_POSITION | NUMBER | NO | The value of this column is NULL. |