Note
This view is available starting with V4.0.0.
Purpose
This view displays the metadata of a table group, including the partition information of the table group.
Note
Starting from V4.2.0, the partition attribute fields in this view will no longer have any meaning and will be uniformly displayed as NONE or NULL.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TABLEGROUP_NAME | VARCHAR2(128) | NO | The name of the table group. |
| PARTITIONING_TYPE | VARCHAR2(13) | NO | The partition type of the primary partition of the table group. Valid values:
|
| SUBPARTITIONING_TYPE | VARCHAR2(13) | NO | The partition type of the subpartition of the table group. Valid values:
|
| PARTITION_COUNT | NUMBER | NO | This value is NULL. |
| DEF_SUBPARTITION_COUNT | NUMBER | NO | This value is NULL. |
| PARTITIONING_KEY_COUNT | NUMBER | NO | This value is NULL. |
| SUBPARTITIONING_KEY_COUNT | NUMBER | NO | This value is NULL. |
| SHARDING | VARCHAR2(20) | NO | The SHARDING attribute of the table group. Valid values:
NoteThis column is available starting with V4.2.0. |
| SCOPE | VARCHAR2(20) | YES | The SCOPE attribute of the table group. Valid values:
NoteFor V5.x versions, this column is available starting with V5.0.1. |
Sample query
Query the attributes of the table group TBLGROUP1.
obclient> SELECT * FROM SYS.DBA_OB_TABLEGROUPS WHERE tablegroup_name = 'TBLGROUP1'\G
The returned result is as follows:
*************************** 1. row ***************************
TABLEGROUP_NAME: TBLGROUP1
PARTITIONING_TYPE: NONE
SUBPARTITIONING_TYPE: NONE
PARTITION_COUNT: NULL
DEF_SUBPARTITION_COUNT: NULL
PARTITIONING_KEY_COUNT: NULL
SUBPARTITIONING_KEY_COUNT: NULL
SHARDING: NONE
SCOPE: ZONE
1 row in set