USER_REFS

Description of the user's own REF columns contained in the user's own tables

Columns
   ___________________________
 
   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
   SCOPE_TABLE_OWNER
      Owner of the scope table, if it exists
   WITH_ROWID
      Is the REF value stored with the rowid?
   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