$page_title = $titlebar_text; $header_bar_text = $titlebar_text; ///////////////////////////////////// // get header include('rlib_header.php'); // print << 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
EOM; ///////////////////////////////////// // get footer include('rlib_footer.php'); ?>