Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Select cluster_name, owner, table_name from dba_tables

SQL> select cluster_name, owner, table_name   2    from dba_tables   3   where cluster_name is not null   4   order by cluster_name   5  / CLUSTER_NAME                   OWNER ------------------------------ ------------------------------ TABLE_NAME ------------------------------ C_COBJ#                        SYS CDEF$ C_COBJ#                        SYS CCOL$ C_FILE#_BLOCK#                 SYS UET$ CLUSTER_NAME                   OWNER ------------------------------ ------------------------------ TABLE_NAME ------------------------------ C_FILE#_BLOCK#                 SYS SEG$ C_MLOG#                        SYS MLOG$ C_MLOG#                        SYS SLOG$ CLUSTER_NAME                   OWNER ------------------------------ ------------------------------ TABLE_NAME ------------------------------ C_OBJ#                         SYS TAB$ C_OBJ#                         SYS CLU$ C_OBJ#                         SYS COL$ CLUSTER_NAME                   OWNER ------------------------------ ------------------------------ TABLE_NAME ------------------------------ C_OBJ#                         SYS IND$ C_OBJ#                         SYS ICOL$ C_OBJ#                         SYS SUBCOLTYPE$ CLUSTER_NAME                   OWNER ------------------------------ ------------------------------ TABLE_NAME ------------------------------ C_OBJ#                         SYS ICOLDEP$ C_OBJ#                         SYS LIBRARY$ C_OBJ#                         SYS OPQTYPE$ CLUSTER_NAME                   OWNER ------------------------------ ------------------------------ TABLE_NAME ------------------------------ C_OBJ#                         SYS NTAB$ C_OBJ#                         SYS TYPE_MISC$ C_OBJ#                         SYS VIEWTRCOL$ CLUSTER_NAME                   OWNER ------------------------------ ------------------------------ TABLE_NAME ------------------------------ C_OBJ#                         SYS ATTRCOL$ C_OBJ#                         SYS REFCON$ C_OBJ#                         SYS COLTYPE$ CLUSTER_NAME                   OWNER ------------------------------ ------------------------------ TABLE_NAME ------------------------------ C_OBJ#                         SYS LOB$ C_OBJ#_INTCOL#                 SYS HISTGRM$ C_RG#                          SYS RGROUP$ CLUSTER_NAME                   OWNER ------------------------------ ------------------------------ TABLE_NAME ------------------------------ C_RG#                          SYS RGCHILD$ C_TOID_VERSION#                SYS TYPE$ C_TOID_VERSION#                SYS COLLECTION$ 36 rows selected. SQL> SQL> SQL> SQL>