DBA_OB_TABLEGROUPS

Purpose

This view displays metadata about table groups, including information about partitions.

Columns

Sample query

1. Create a table group named tblgroup1.

   obclient [SYS]> CREATE TABLEGROUP tblgroup1 SHARDING = 'PARTITION';
   

2. Query the SHARDING attribute of the TBLGROUP1 table group.

   obclient [SYS]> SELECT TABLEGROUP_NAME, SHARDING FROM SYS.DBA_OB_TABLEGROUPS WHERE tablegroup_name = 'TBLGROUP1';
   

   The query result is as follows:

   +-----------------+-----------+
   | TABLEGROUP_NAME | SHARDING  |
   +-----------------+-----------+
   | TBLGROUP1       | PARTITION |
   +-----------------+-----------+
   1 row in set
   

References

Table groups