select 'CREATE SYNONYM  ' || owner || '.' || synonym_name ||' FOR ' || table_name || ';'
from dba_synonyms
where table_owner = 'USERNAME'
order by table_name;