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