Recreate

Solution for ORA-02303 from JSON_OBJECT_INVALID in upgrade to 19c

Posted on October 30, 2020 by Mike.Dietrich Flaws and Pitfalls 0

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.

Solution for ORA-02303 from JSON_OBJECT_INVALID in upgrade to 19c

Photo by Pankaj Patel on Unsplash

What happens?

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 …

In case you miss DBMS_OPTIM_BUNDLE in 12.2

Posted on February 11, 2019 by Mike.Dietrich Flaws and Pitfalls 0

Strange things happen sometimes. I got alerted by a customer before Christmas about package DBMS_OPTIM_BUNDLE missing after applying a Release Update. I’ve had a conversation with Nigel Bayliss, the Optimizer PM – but Nigel hasn’t heard of such things either. We both investigated but couldn’t reproduce the issue. But after the end-of-the-year holidays I received similar messages from other customers. In case you miss DBMS_OPTIM_BUNDLE in 12.2, then this blog post should help you.