ALL_SYNONYMS view provides information on all synonyms that may be referenced by the current user.
|User name of the synonym’s owner.|
|The name of the schema in which the synonym resides.|
|Name of the synonym.|
|User name of the object’s owner.|
|The name of the schema in which the table resides.|
|The name of the object that the synonym refers to.|
|The name of any associated database link.|