select cluster_name, owner, table_name from dba_tables : DBA_Tables « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. DBA_Tables

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>








Related examples in the same category

1.Get owner, table name and table space name from dba_tables
2.Data Dictionary Scope
3.Query dba_tables for table info
4.Query dba_tables by owners