DBA_SYNONYM view provides information about all synonyms in the database.
|User name of the synonym’s owner.|
|Name of the schema in which the synonym belongs.|
|Name of the synonym.|
|User name of the table’s owner on which the synonym is defined.|
|The name of the schema in which the table resides.|
|Name of the table on which the synonym is defined.|
|Name of any associated database link.|