SHARDED_TABLE_FAMILIES

The SHARDED_TABLE_FAMILIES public view shows all sharded tables and the corresponding root table and schema names.

Column	Data Type	NULL	Description
`TABFAM_ID`	`NUMBER`		This unique table family identifier is a numeric value and each table family is assigned a unique number
`ROOT_SCHEMA_NAME`	`VARCHAR2(128)`		The schema owning root (parent) table for a table family
`ROOT_TABLE_NAME`	`VARCHAR2(128)`		The root (parent) table name for a table family
`SCHEMA_NAME`	`VARCHAR2(128)`		The schema name for tables
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	The table name

Sample Output

The following is sample output from a query on the SHARDED_TABLE_FAMILIES view. In this table family customers1 is root table, and orders1 and lineitems1 are the child tables of customers1.

SQL> select * from SHARDED_TABLE_FAMILIES order by TABFAM_ID,ROOT_SCHEMA_NAME,ROOT_TABLE_NAME,SCHEMA_NAME,TABLE_NAME;

 TABFAM_ID ROOT_SCHEMA_NAM ROOT_TABLE_NAME SCHEMA_NAM TABLE_NAME
---------- --------------- --------------- ---------- ---------------
         6 TESTUSER1       CUSTOMERS1      TESTUSER1  CUSTOMERS1 
         6 TESTUSER1       CUSTOMERS1      TESTUSER1  LINEITEMS1
         6 TESTUSER1       CUSTOMERS1      TESTUSER1  ORDERS1

        10 TESTUSER1       CUSTOMERS2      TESTUSER1  CUSTOMERS2
        10 TESTUSER1       CUSTOMERS2      TESTUSER1  LINEITEMS2
        10 TESTUSER1       CUSTOMERS2      TESTUSER1  ORDERS2

        13 TESTUSER1       CUSTOMERS3      TESTUSER1  CUSTOMERS3
        13 TESTUSER1       CUSTOMERS3      TESTUSER1  LINEITEMS3
        13 TESTUSER1       CUSTOMERS3      TESTUSER1  ORDERS3

Parent topic: Oracle Sharding Reference