Oracle Edition Based Redefinition
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
Purpose  
Dependencies
ALL_EDITIONING_VIEWS DBA_EDITIONING_VIEWS_AE KU$_EDITION_TRIG_EXISTS_VIEW
ALL_EDITIONING_VIEWS_AE DBA_EDITIONING_VIEW_COLS KU$_USER_EDITIONING_LIST_T
ALL_EDITIONING_VIEW_COLS DBA_EDITIONING_VIEW_COLS_AE KU$_USER_EDITIONING_T
ALL_EDITIONING_VIEW_COLS_AE DBA_EDITIONS KU$_USER_EDITIONING_VIEW
ALL_EDITIONS DBA_EDITION_COMMENTS USABLE_EDITIONS
ALL_EDITION_COMMENTS DBMS_EDITIONS_UTILITIES USER_EDITIONED_TYPES
CDB_EDITIONED_TYPES DBMS_EDITIONS_UTILITIES_LIB USER_EDITIONING$
CDB_EDITIONING_VIEWS EDITION$ USER_EDITIONING_VIEWS
CDB_EDITIONING_VIEWS_AE EDITIONING_TYPES$ USER_EDITIONING_VIEWS_AE
CDB_EDITIONING_VIEW_COLS FED$EDITIONS USER_EDITIONING_VIEW_COLS
CDB_EDITIONING_VIEW_COLS_AE GV$EDITIONABLE_TYPES USER_EDITIONING_VIEW_COLS_AE
CDB_EDITIONS I_USER_EDITIONING V$EDITIONABLE_TYPES
CDB_EDITION_COMMENTS KU$_EDITION_OBJ_VIEW _ACTUAL_EDITION_OBJ
DBA_EDITIONED_TYPES KU$_EDITION_PROC_EXISTS_VIEW _CURRENT_EDITION_OBJ
DBA_EDITIONING_VIEWS 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.

Related Topics
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 21c
What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx