This discussion is archived
5 Replies Latest reply: Aug 22, 2013 4:33 AM by abdulwahab RSS

Help needed in 10gR2 to 11gR2 EBS Database Upgrade

abdulwahab Newbie
Currently Being Moderated


I am upgrading EBS Database from 10gR2 ( to 11gR2 While going through Oracle Note Complete Checklist for Manual Upgrades to 11gR2 [ID 837570.1], under the point 3 of "Recommendations from Source database" it says:

"Disable the custom triggers that would fire before/after DDL and enable them after the upgrade is complete."

I want to know is it compulsory to disable the custom triggers? If yes then how can I get the list of those custom triggers and disable/enable them before and after the database upgrade?

Please let me know the commands. My operating system is Oracle Enterprise Linux 5.8.





  • Correct Answers - 10 points
  • Helpful Answers - 5 points