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

Hi,

I am upgrading EBS Database from 10gR2 (10.2.0.3) to 11gR2 11.2.0.3. 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.

 

Thanks,

Abdul

Legend

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