Re: ad & txk 9 upgrade

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

fixing this sql is a developer work.. It has XML related things.
Anyways, I suggest you to take the scripts of these synonym from another environment.

you can use dba_synonyms for this

select * from dba_synonyms where table_name like '%APPS_DDL%'

Check the name of the synonym from the output of the query above.. (check the public one)

After that, take the scripts of the synonym and create it on this database where the patch is failing.

Lastly, comment out the problematic sql in the patch file (adsysapp2.sql) and reapply the patch..

Update me.