Note
This view is available starting with V4.0.0.
Purpose
This view displays the association between tables and table groups in the current tenant. It does not display tables that are not in any table group.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TableGROUP_NAME | VARCHAR2(128) | NO | The name of the table group. |
| OWNER | VARCHAR2(128) | YES | The name of the database to which the table belongs. |
| TABLE_NAME | VARCHAR2(256) | YES | The name of the table. |
| SHARDING | VARCHAR2(20) | NO | The SHARDING attribute of the table group. Valid values:
|
| SCOPE | VARCHAR2(20) | YES | The SCOPE attribute of the table group. Valid values:
NoteThis column is available starting with V5.0.1 for V5.x series. |
Sample query
Query the association between tables and the table group named TBLGROUP2 in the current tenant.
obclient> SELECT * FROM SYS.DBA_OB_TABLEGROUP_TABLES WHERE tablegroup_name = 'TBLGROUP2';
The return result is as follows:
+-----------------+--------------+------------+----------+--------+
| TABLEGROUP_NAME | OWNER | TABLE_NAME | SHARDING | SCOPE |
+-----------------+--------------+------------+----------+--------+
| TBLGROUP2 | TEST_USER001 | TEST_TBL3 | NONE | SERVER |
| TBLGROUP2 | TEST_USER001 | TEST_TBL4 | NONE | SERVER |
+-----------------+--------------+------------+----------+--------+
2 rows in set