DATABASE SYNONYM NOTES

 

Synonyms

DATABASE SYNONYM NOTES:

Owner - Owner of the synonym

Name - Name of the synonym

Table Owner - Owner of the table

Table Name - Name of the table

DB Link - Name of the database link

select OWNER,
 SYNONYM_NAME,
 TABLE_OWNER,
 TABLE_NAME,
 DB_LINK
from   dba_synonyms
where owner not in ('SYS','SYSTEM','PUBLIC','DBSNMP')
order  by OWNER,SYNONYM_NAME