spool crpubsyn.sql
SELECT 'CREATE PUBLIC SYNONYM '||synonym_name||' FOR '||table_owner||'.'||table_name||';'FROM dba_synonymsWHERE owner = 'PUBLIC';
spool off