Creating trigger: ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property of
Hi all,
Our customer executes a script, creating trigger on Oracle DB 12.2 editionable enabled:
create or replace trigger MVOA_FND_ATTACHED_DOCS_DEL
before delete on FND_ATTACHED_DOCUMENTS
referencing old as OLD new as NEW
for each row
DECLARE
...
An error 'ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property of an existing object' occurs.
I can not reproduce the issue. 'Create or replace trigger' command is rerunnable in my envinronment (schema is also editionable enabled).
What could be a reason of the exception and a difference?
On my env select editionable from all_objects where object_name = 'MVOA_FND_ATTACHED_DOCS_DEL'