Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Disable EBR during 19c database upgrade?

user1165418Apr 2 2020 — edited Apr 6 2020

Hi All,

We have upgraded Oracle EBS to 12.2.7. We are now prepping to upgrade the 12.1.0.2 Enterprise Database up to 19.3.

The 19c database upgrade instructions (Doc ID 2539778.1) say “Disable any custom triggers that would get executed before / after DDL. You can enable it once upgrade is completed.”

We are using Edition Based Redefinition (EBR). Do we simply disable all triggers on tables owned by APPS? Than re-enable them afterwards?

Any thoughts (and references) would be appreciated.

Added on Apr 2 2020

#database-upgrade

5 comments

920 views