DBA_SYNONYMS v10

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

NameTypeDescription
ownerTEXTUser name of the synonym’s owner.
schema_nameTEXTName of the schema in which the synonym belongs.
synonym_nameTEXTName of the synonym.
table_ownerTEXTUser name of the table’s owner on which the synonym is defined.
table_schema_nameTEXTThe name 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.