Hello,
We have created the multiple Editions in oracle 19c while dropping the editions using cascade we are getting below error.
ora-38810 implementation restriction cannot drop edition that has a parent and a child.
Request your help/suggestions to drop the editions.
We have performed below steps to drop and edition.
1) Created below three editions. Using below command.
CREATE EDITION E1 AS CHILD OF ORA$BASE;
EDITION_NAME PARENT_EDITION_NAME USABLE
ORA$BASE YES
E1 ORA$BASE YES
E2 E1 YES
E3 E2 YES
alter session set edition =E1;
Alter database default edition = E1;
Above all three steps performed for three editions and now current edition is set to E3;
select sys_context('USERENV','CURRENT_EDITION_NAME') from dual;
SYS_CONTEXT('USERENV','CURRENT_EDITION_NAME')
E3
select * from database_properties where property_name = 'DEFAULT_EDITION';
Output:
PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
DEFAULT_EDITION E3 Name of the database default edition
Now, We want to retire Edition E1 we performed below steps.
1) Checked the privilege's using below query.
SELECT *--GRANTEE, PRIVILEGE
FROM DBA_TAB_PRIVS
WHERE TABLE_NAME = 'E1';
GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRANTABLE HIERARCHY COMMON TYPE INHERITED
IT7_HOST SYS E1 SYS USE YES NO NO EDITION NO
2) Revoked privilege's of schema using below command.
REVOKE USE ON EDITION E1 FROM IT7_HOST;
DROP EDITION E1 CASCADE;
Getting below error while dropping;
ora-38810 implementation restriction cannot drop edition that has a parent and a child
4) dba_editions view shows below output.
EDITION_NAME PARENT_EDITION_NAME USABLE
ORA$BASE YES
E1 ORA$BASE YES
E2 E1 YES
E3 E2 YES
Regards
GirishR
The edition E1 has a parent (ORA$BASE) and a child (E2).
As the error says, you can't do this!
The only editions you can drop are the root and the leaf. Which are ORA$BASE and E3 in this case.
So if you want to remove E1, either you need to first
Drop ORA$BASE
OR
Drop E3, then drop E2.
Or you could leave E1 in place. As you've revoked user IT7_HOST access to this edition, it can no longer use it.