The DBA_SYNONYM view provides the information about all synonyms in the database.
| Parameter | Type | Description |
|---|---|---|
| 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. |