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