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) | NO | The name of the database to which the table belongs. |
| TABLE_NAME | VARCHAR2(256) | NO | The name of the table. |
| SHARDING | VARCHAR2(20) | NO | The SHARDING attribute of the table group. Valid values:
|
Sample query
Query the association between tables and the table group named TBLGROUP1 in the current tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_TABLEGROUP_TABLES WHERE tablegroup_name = 'TBLGROUP1';
The query result is as follows:
+-----------------+-------+------------+----------+
| TABLEGROUP_NAME | OWNER | TABLE_NAME | SHARDING |
+-----------------+-------+------------+----------+
| TBLGROUP1 | SYS | TBL3 | NONE |
+-----------------+-------+------------+----------+
1 row in set