DBA_SYNONYMS v17
The DBA_SYNONYM
view provides information about all synonyms in the database.
Name | Type | Description |
---|---|---|
owner | TEXT | User name of the synonym owner. |
schema_name | TEXT | Name of the schema in which the synonym belongs. |
synonym_name | TEXT | Name of the synonym. |
table_owner | TEXT | User name of the owner of the table on which the synonym is defined. |
table_schema_name | TEXT | Name of the schema in which the table resides. |
table_name | TEXT | Name of the table on which the synonym is defined. |
db_link | TEXT | Name of any associated database link. |