Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_SYNONYMS

All synonyms in the database 

Columns
   ___________________________
 
   OWNER
      Username of the 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