The DBA_SYNONYM view provides the information about all synonyms in the database.
|owner||TEXT||The username of the owner to which a synonym belongs.|
|schema_name||TEXT||The name of the schema to which the synonym belongs.|
|synonym_name||TEXT||The name of the synonym.|
|table_owner||TEXT||The username of the owner of the table on which the synonym is defined.|
|Table_schema_name||TEXT||The name of the schema to which the table belongs.|
|table_name||TEXT||The name of the table on which the synonym is defined.|
|db_link||TEXT||The name of any associated database link.|