Skip to Main Content

SQL & PL/SQL

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 implement EBR approach in Oracle DB

curious_mindDec 27 2018 — edited Dec 27 2018

Hi All,

We have a requirement to go for zero Outage for our package promotion from lower to Production environment. Currently when DBA is executing any package changes then during the execution our consumers are facing outage. we have to get rid of this problem. We are using Oracle 12c version.

recently we came across one solution called EBR(Edition based redefinition) where we can save this outage but unable to find like how to implement this approach in our DB as so much of documentation is present online but not getting the exact steps i have to follow to implement this.

Please help.

Comments
Post Details
Added on Dec 27 2018
1 comment
424 views