Home Oracle Commands Oracle Data Dictionary
v$ Performance views

ALL_SYNONYMS

All synonyms accessible to the user 

Columns
   ___________________________
 
   OWNER
      Owner of the synonym
   SYNONYM_NAME
      Name of the synonym
   TABLE_OWNER
      Owner of the object referenced by the synonym
   TABLE_NAME
      Name of the object referenced by the synonym
   DB_LINK
      Name of the database link referenced in a remote synonym

Related:


Simon Sheppard
 SS64.com