CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_EDITIONS_UTILITIES
Version 11.1
 
General Information
Source {ORACLE_HOME}/rdbms/admin/dbmsedu.sql
First Available 11.1
Dependencies
ALL_ALL_TABLES ALL_VIEWS_AE DBMS_SQL
ALL_EDITIONING_VIEWS_AE DBMS_ASSERT USER_SYS_PRIVS
ALL_TAB_PRIVS DBMS_OUTPUT  

Exceptions
Error Code Reason
-38802 Edition does not exist
-38803 Edition is unusable
-38804 Not a legal edition name
-38805 Edition is in use
-38806 Edition is being altered or dropped
-38807 Implementation restriction: an edition can have only one child
-38808 Edition has a usable parent and a usable child
-38809 Edition must be unusable
-38810 Implementation restriction: can not drop an edition that has a parent and a child
-38811 Need CASCADE option to drop edition that has actual objects
-38812 Maximum number of editions reached
-38813 editions not supported for schema <schema_name>
-38814 ALTER SESSION SET EDITION must be first statement of transaction
-38815 ALTER SESSION SET EDITION must be a top-level SQL statement
-38816 Edition has a child that inherits objects from the edition
-38817 Insufficient Privileges
-00942 Missing Table
Security Model Execute is granted to PUBLIC
 
SET_EDITIONING_VIEWS_READ_ONLY

Given the table name, set the all the Editioning views in all editions to read-only or read write
dbms_editions_utilities.set_editioning_views_read_only(
table_name IN VARCHAR2,
owner      IN VARCHAR2 DEFAULT NULL,
read_only  IN BOOLEAN DEFAULT TRUE);
SELECT *
FROM dba_editions;

desc dba_views

SELECT view_name, editioning_view, read_only
FROM dba_views
WHERE owner = 'SH';

set long 1000000

SELECT text
FROM dba_views
WHERE owner = 'SH'
AND view_name = 'PROFITS';

exec dbms_editions_utilities.set_editioning_views_read_only('SALES', 'SH', TRUE);
 
Related Topics
Editions
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [63 users online]    © 2010 psoug.org