extract parus synonyms Oracle select 'create public synonym ' || synonym_name ||
' for ' || table_owner || '.' || table_name || ';'
from dba_synonyms
where owner = 'PUBLIC'
and table_owner = 'PARUS'
/