5 Replies Latest reply on Aug 22, 2013 11:33 AM by abdulwahab

    Help needed in 10gR2 to 11gR2 EBS Database Upgrade



      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.