Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error: ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property of an existing

User_VEQCBDec 11 2019 — edited Dec 12 2019

Hi,

I am getting error as Error: ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property of an existing object when trying to change the trigger

create or replace TRIGGER SAMPLE_TRIGGER

BEFORE INSERT OR UPDATE OR DELETE ON SAMPLE_USER

FOR EACH ROW

  --

  --

END;

the schema is Editioning enabled ,

Can you please help on how to resolve this error .

Thanks,

Comments
Post Details
Added on Dec 11 2019
6 comments
18,006 views