/* RUN this script on d0ofprd1 then run the output on Luminosity db */
spool trig_syn.out
set head off
set feed off
set linesize 132
select 'create public synonym ' || synonym_name || ' for ' || table_owner || '.' || table_name || '@d0ofprd1;' from all_synonyms where table_owner = 'TRIGGER_OWNER'
order by synonym_name
/
spool off
