Summary: Edition-Based Redefinition, enables DBAs and end users to access more than one occurrence of a stored procedure, a trigger, a view, and other objects and therefore to stage—in isolation—the changes in a schema. Starting with Oracle Database 11g Release 2, a single schema can now have two or more “versions” of a stored PL/SQL unit (function, type, trigger, and so on) or a view or synonym and all of their related metadata such as GRANTs on those objects. The feature that permits this is the new edition object type. This podcast will describe EBR and discuss the concepts of this exciting new Oracle 11g feature.
