_____________________________________________________________________________________

Managing Synonyms:
https://docs.oracle.com/cd/E11882_01/server.112/e25494/views.htm#ADMIN11805
_____________________________________________________________________________________

set pages 1000
set lines 200
_____________________________________________________________________________________

GENERAL INFO (DBA_SYNONYMS)
===========================
https://docs.oracle.com/cd/E11882_01/server.112/e40402/statviews_2100.htm#REFRN20273

select owner, synonym_name, table_owner, table_name, db_link
from dba_synonyms;

select synonym_name, db_link
from dba_synonyms
where owner = 'PUBLIC'
and upper(synonym_name) like upper('XXXNAMEXXX%') order by 1;

select synonym_name, table_owner, table_name, db_link
from dba_synonyms
where owner = 'PUBLIC'
and upper(synonym_name) like upper('XXXNAMEXXX%') order by 1;
_____________________________________________________________________________________