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); |