DBA_SYNONYMS v17

The DBA_SYNONYM view provides information about all synonyms in the database.

NameTypeDescription
ownerTEXTUser name of the synonym owner.
schema_nameTEXTName of the schema in which the synonym belongs.
synonym_nameTEXTName of the synonym.
table_ownerTEXTUser name of the owner of the table on which the synonym is defined.
table_schema_nameTEXTName of the schema in which the table resides.
table_nameTEXTName of the table on which the synonym is defined.
db_linkTEXTName of any associated database link.