|Oracle Editioning Views
|Purpose||Editioning views are the second tier of the Edition Based Redefinition architecture.
They must be preceded by edition enabling the user and may be optionally followed by the creation of cross-edition triggers.
This page demonstrates both what can, and can not, be done with editioning views.
That said it is still far from complete and the reader is advised to thoroughly review the docs at http://docs.oracle.com
an far more importantly to download a copy of Bryn Llewellyn's Editioning White Paper.
What is most critical to understand is that due to the tight restrictions on what is permissible in an Editioning View there are no performance penalties for accessing a table through an editioning view, rather than directly: And there never will be.
|Create Single Table Editioning View||CREATE OR REPLACE [[NO] FORCE] EDITIONING VIEW <view_name> AS <select_statement>;|
|CREATE TABLE ebr_tab (
CREATE OR REPLACE VIEW reg_view AS
CREATE OR REPLACE EDITIONING VIEW ed_view AS
SELECT * FROM reg_view;
SELECT * FROM ed_view;
SELECT view_name, editioning_view
SELECT * FROM user_editioning_views_ae;
SELECT view_name, view_column_name, table_column_name, edition_name
|Forces creation of a view even when the view will be invalid. NO FORCE is the default||CREATE OR REPLACE [[NO] FORCE] EDITIONING VIEW <view_name> AS <select_statement>;|
|CREATE OR REPLACE FORCE EDITIONING VIEW ed_view AS
|Recompile an invalid editioning view||ALTER VIEW <view_name> COMPILE;|
|ALTER VIEW ed_view COMPILE;|
|Drop Editioning View||DROP VIEW <view_name>;|
|ALTER VIEW ed_view;|
|Editioning View Restrictions|
|Note||The following demos are designed to create errors to illustrate both what does, and what does not, work. Examine each carefully before trying first the version on the left then the version on the right. There are many more restrictions than those demonstrated below. Be sure to consult the docs for restrictions before creating an Editioning View.|
|Editioning Demo 1|
|Editioning Demo 2|
|Editioning Demo 3|
|Editioning Demo 4|
|Editioning Demo 5|
|Editioning Demo 6|
|Editioning Demo 7|
|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-2014 Daniel A. Morgan All Rights Reserved|