■ 시너님 추출 script

======================================================================
=================

select
        'create '
        ||DECODE(owner,'PUBLIC','public')||' synonym '
        ||DECODE(owner,'PUBLIC',Null, '')||synonym_name
        ||' for '
        ||DECODE(table_owner,Null,''||table_name,table_owner||'.'||table_name)

        ||DECODE(db_link,Null,';', '@'||db_link||';')
from    dba_synonyms
where /*table_owner \*not in ('SYS','SYSTEM')*\='PRSADMIN'
or*/ owner='PRSADMIN'
--or table_owner ='PRSADMIN'