Access articles and resources written by some of the best Oracle brains in the world.

Edition Based Redefinition
Presented by Patrick Barel (Oracle ACE)
Weds 13th February 2013
This webinar has now finished, but feel free to click the button above to watch the recording.
Summary
Upgrading critical applications can be very hard and one of the biggest problems organizations face is the availability of the application during the update. Because of the global nature of applications nowadays we want to achieve 99.99% uptime. Since Oracle Database 11g Release 2 Edition Based Redefinition is available to solve this issue.
In this session, Patrick Barel will introduce the ideas behind Edition Based Redefinition and how it can be used. He will look at tables, editioning views, cross edition triggers, and how PL/SQL Code can be changed in the different editions.
After this session you will have a basic idea on how Edition Based Redefinition works and how it might help you in your situation.
A live Q+A with Patrick Barel will follow the presentation
Patrick Barel
Patrick Barel is a PL/SQL Developer for AMIS Services in the Netherlands and an Oracle ACE. Besides working with SQL and PL/SQL he co-developed CodeGen and wrote different plug-ins for PL/SQL Developer. He publishes articles on the AMIS Technology blog, All Things Oracle.com and on his own blog.
Data Compare for Oracle
- Compare 2 tables and see highlighted differences side-by-side
- Automatically create update scripts to migrate any changes

