recreate synonyms

select ‘create public synonym ‘synonym_name’ for ‘table_owner’.'table_name’;’from dba_synonyms where table_owner=’ownername’ or owner in 'ownername'
/