DBA_REFS

Description of REF columns contained in all tables

Columns
   ___________________________
 
   SCOPE_TABLE_OWNER
      Owner of the scope table, if it exists
   COLUMN_NAME
      Column name or attribute of object column
   OBJECT_ID_TYPE
      If ref contains user-defined OID, then USER-DEFINED, else if it contains system generated OID, then SYSTEM GENERATED
   SCOPE_TABLE_NAME
      Name of the scope table, if it exists
   WITH_ROWID
      Is the REF value stored with the rowid?
   OWNER
      Owner of the table containing the REF column
   TABLE_NAME
      Name of the table containing the REF column
   IS_SCOPED
      Is the REF column scoped?

Related Commands:

   DBA_TYPES     ALL_TYPES    USER_TYPES

Simon Sheppard
SS64.com