I just learned yesterday about this error – and as it seems to happen occasionally, you may want to read more about the Solution for ORA-02303 from JSON_OBJECT_INVALID in upgrade to 19c.
You are upgrading a database to Oracle 19c, and you see this error pattern:
CREATE OR REPLACE TYPE JSON_Object_T AUTHID CURRENT_USER UNDER JSON_Element_T( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents
This is coming when catjson.sql gets executed.
Why does it happen?
Unfortunately the FORCE option is missing when we create …Continue reading...