ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property during Apex install in 12.2

Introduction

Solution to fix ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property during Apex install in 12.2

Posted by Sathiyaseelan

Issue:

Fresh apex install failed with the below error.

ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property during Apex install in 12.2

This is due to previous version of flow_files installed in the the database.

Solution:

Check whether old version is installed and use drop schema and retry the installation.

select username from dba_users where username like ‘%FLOW%’