OCI-38824
A CREATE OR REPLACE command cannot change the EDITIONABLE property of the following object: 'object_name'.
- object_name: The name of the object.
Cause
An attempt was made to replace an existing object with a different value for the EDITIONABLE property.
Action
Run this query to check the EDITIONABLE property for the object:
SELECT editionable FROM all_objects WHERE object_name = '<object_name>' AND owner = '<object_owner>';
If this returns Y, then change the REPLACE statement to EDITIONABLE, for example:
CREATE OR REPLACE EDITIONABLE ...
If the query returns N, then use NONEDITIONABLE, for example:
CREATE OR REPLACE NONEDITIONABLE ...
Use ALTER to change the EDITIONABLE property for the object. The syntax to do this is:
ALTER <object_type> [<object_owner>.]<object_name> ( NONEDITIONABLE | EDITIONABLE );