Edition-Based Redefinition

Oracle Database 11g introduced edition-based redefinition (EBR), a new concept in the Oracle Database that is available for all editions of the database at no extra cost. Over the years a number of technologies have been used to reduce the downtime of the Oracle Database. The one thing that could keep users working uninterrupted was the actual database application they were using. Upgrading the database application always required downtime; it was simply not possible to replace PL/SQL objects that were in use.

The whole purpose of edition-based redefinition is to have zero downtime. However, the concept of edition-based ...

Get Real World SQL and PL/SQL: Advice from the Experts now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.