Oracle Edition Based Redefinition
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Header
The Library is currently in the process of being upgraded from Oracle Database Version to 12.2.0.1 and version 18.0 is going to be available soon. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c and beyond.

Have you viewed the Library's main Table of Contents? If not ... [Click Here] ... scroll down the page and you will find links to the largest collection of Oracle Database demos on the net.
Purpose  
Dependencies
ALL_EDITIONING_VIEWS CDB_EDITION_COMMENTS KU$_EDITION_TRIG_EXISTS_VIEW
ALL_EDITIONING_VIEWS_AE DBA_EDITIONED_TYPES KU$_USER_EDITIONING_VIEW
ALL_EDITIONING_VIEW_COLS DBA_EDITIONING_VIEWS USABLE_EDITIONS
ALL_EDITIONING_VIEW_COLS_AE DBA_EDITIONING_VIEWS_AE USER_EDITIONED_TYPES
ALL_EDITIONS DBA_EDITIONING_VIEW_COLS USER_EDITIONING_VIEWS
ALL_EDITION_COMMENTS DBA_EDITIONING_VIEW_COLS_AE USER_EDITIONING_VIEWS_AE
CDB_EDITIONED_TYPES DBA_EDITIONS USER_EDITIONING_VIEW_COLS
CDB_EDITIONING_VIEWS DBA_EDITION_COMMENTS USER_EDITIONING_VIEW_COLS_AE
CDB_EDITIONING_VIEWS_AE GV_$EDITIONABLE_TYPES V_$EDITIONABLE_TYPES
CDB_EDITIONING_VIEW_COLS KU$_EDITION_OBJ_VIEW _ACTUAL_EDITION_OBJ
CDB_EDITIONING_VIEW_COLS_AE KU$_EDITION_PROC_EXISTS_VIEW _CURRENT_EDITION_OBJ
CDB_EDITIONS KU$_EDITION_SCHEMAOBJ_VIEW  
 
EBR Library Topics
Library Page Scenario Examples
CrossEdition Triggers CrossEdition triggers are used to populate columns in the new version of the application from columns in the previously existing version of the table. The reverse is also true.
Editions An edition is a new type of database object that makes possible the magic that is editioning.
Editioning Views Editioning views are a special type of view used to present to each edition those table columns that are appropriate for users of that edition's application code.
Editioning Demo 1 This demo covers edition creation, edition commenting, editionable objects, and making editioned objects visible to application users.
Editioning Demo 2 This demo builds on demo 1 and demonstrates the use of editioning views.
Editioning Demo 3 This demo builds on demo 2 and demonstrates the use of crossedition triggers and the FOLLOWS and PRECEDES clauses.
Editioning Demo 4 This demo shows two methods of updating a table due to column modifications specific to editioning.
Editioning Demo 5 This demo shows how to use invisible indexes to make new, post-upgrade, indexes invisible to the pre-upgrade application
Editioning Demo 6 This demo shows how to automate the process renaming tables, creating editioning views, and recreating DML triggers.
Editioning Demo 7 This demo shows how to patch a PL/SQL object while it is in use.
 
EBR Wish List Description
ALTER editionability As of 12.1.0.1 a PL/SQL object can be declare editionable or noneditionable.
Function Based Indexes Should respect user defined functions based on the edition in which they were created.
Indexes Index visibility, to the CBO, should be controllable by edition (parent, child, all) during CREATE and ALTER operations.
Operators Should respect user defined functions based on the edition in which they were created.

Related Topics
DBMS_CDC_UTILITY
DBMS_METADATA_UTIL
DBMS_PARALLEL_EXECUTE
DBMS_PARALLEL_EXECUTE_INTERNAL
DBMS_PDB_ALTER_SHARING
DBMS_REDEFINITION
DBMS_SESSION
DBMS_SQL
DBMS_SYS_SQL
DBMS_UTILITY
DDL_LOCK_TIMEOUT
Invisible Indexes
Procedures
SYS_CONTEXT
Table Triggers
Views
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved