Editions are easily created
EBR (Edition-Based Redefinition)
Oracle states:
Edition-based redefinition (EBR) enables online application upgrade with uninterrupted availability of the application.
The Oracle GoldenGate 18c online documentation
Has information regarding the support of this:
https://docs.oracle.com/database/121/ADFNS/adfns_editions.htm#ADFNS020
http://ermanarslan.blogspot.com/2015/07/ebs-122-and-ebr-lets-make-demo.html
https://oracle-base.com/articles/12c/edition-based-redefinition-enhancements-12cr1
Two excellent lessons from the developer of EBR:
https://www.youtube.com/watch?v=bClWlW6tsb4
https://www.youtube.com/watch?v=A2JGbQ839us
Forward, Reverse Cross Edition Triggers and Editioning Views – An integral part of ADOP
Editioning Views
<pre>CREATE OR REPLACE EDITIONING VIEW MRC.EMP# AS SELECT ID AS ID, NAME AS NAME FROM EMP;
=========================================================================
youtube video series
Bryn LLewellyn
Lesson 1 Part 1 40:54
Lesson 1 Part 2 43:54
Lesson 2 52:13
Structure of table change 1:30
Lesson 3 Part 1 41:20
1:09 What is “safe” in
Patching is defined as DDL
Describe the experiment
Lesson 3 Part 2 48:00
Lesson 4 Part 1 41:05
Lesson 4 Part 2 50:03
Lesson 4 Part 3 57:59
Test