Re: ad & txk 9 upgrade

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ad-txk-9-upgrade-tp2945p2972.html

What do you get, when run this sql in your database with apps?

select 'create or replace public synonym '||list.synname||
       ' for system.'||list.synname as text
from   (select trim(t.column_value) synname
        from   xmltable(('"AD_DDL","AD_INST"')) t) list
where  not exists (select null from dba_synonyms where
                   synonym_name = list.synname and owner='PUBLIC'
                   and table_name=synonym_name and table_owner='SYSTEM');

---*check out the ' and " characters when copying and pasting