Export Oracle Synonyms

set pagesize 500;
set linesize 256;
spool /tmp/oracleSynonyms.sql;

select 'create or replace '|| decode(owner,'PUBLIC','public ',null) ||
'synonym ' || decode(owner,'PUBLIC',null, lower(owner) || '.') ||
lower(synonym_name) || ' for ' || lower(table_owner) || '.' || lower(table_name) || decode(db_link,null,null,'@'||db_link) || ';'
from sys.dba_synonyms
where table_owner not in('SI_INFORMTN_SCHEMA','SYS','SYSTEM','ORDSYS','XDB','CTXSYS','DMSYS','EXFSYS','MDSYS','SYSMAN','WKSYS','WMSYS')
order by owner, table_name;

spool off;