The ALL_SYNONYMS view provides the information on all synonyms that may be referenced by the current user.
|owner||TEXT||The username of the owner to which the 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 to which the object belongs.|
|table_schema_name||TEXT||The name of the schema to which the table belongs.|
|table_name||TEXT||The name of the object that the synonym refers to.|
|db_link||TEXT||The name of any associated database link.|