Table: DBA_SYNONYMS
All synonyms in the database
| Column Name | Description |
|---|---|
| DB_LINK | Name of the database link referenced in a remote synonym |
| OWNER | Username of the owner of the synonym |
| SYNONYM_NAME | Name of the synonym |
| TABLE_NAME | Name of the object referenced by the synonym |
| TABLE_OWNER | Owner of the object referenced by the synonym |