ALL_SYNONYMS

The ALL_SYNONYMS view provides information about the synonyms accessible to the current user.

Column name	Data type	Description
OWNER	VARCHAR2(30)	The owner of the synonym. Always INLINE.
SYNONYM_NAME	VARCHAR2(30)	The name of the synonym. Always INLINE.
TABLE_OWNER	VARCHAR2(30)	The owner of the object referenced by the synonym, or the creator of the referring synonym if the target is a public synonym. Always INLINE.
TABLE_NAME	VARCHAR2(30)	The name of the object referenced by the synonym. Always INLINE.
DB_LINK	VARCHAR2(128)	Not used. Reserved for future use. Always NULL, INLINE.
ORIGIN_CON_ID	VARCHAR2(256)	The ID of the container where the data originates. The possible values are: 0 – Used for rows in non-CDBs. n – Used for rows containing data that originate in the container with container ID n (n = 1 if the row originates in the root).