Oracle Edition Based Redefinition the end of a BIG BANG for application upgrades
When upgrading an application or implementing improvements on stored PL/SQL procedures rule is compiling of those objects needed. During this phase, the end users can not using the application, they must wait until the whole change in the application implemented is finished or otherwise unexpected behavior may occur. In Oracle 11g Release 2 this problem is solved by usubg editions. With editions it is now possible to do live deployments of the new code to compile, whitehout users have to wait for implementing the changes. This is the end of a 'BIG BANG' at application upgrades. It is even possible to have multiple application versions operational. In this blog i will descibe the mechanism of the Edition Based Redefinition .