Database Administration (MOSC)

MOSC Banner

Patch for ORA-03001 ORA-02070: database does not support subqueries in this context in Oracle 19c.

There is a query that works in several versions of Oracle Database Oracle 12cR2, Oracle 12cR1, Oracle 11gR2, but does not work in Oracle 19c (19.3.0.0.0).

The error occurs:

ORA-03001: unimplemented feature

ORA-02070: database does not support subqueries in this context

The workaround to resolve this error was:

alter system set optimizer_features_enable='12.2.0.1';

I encountered the following error

Bug 30453957 : SQL QUERY FAILS TO PARSE IN 18C WITH ORA-03001 AND ORA-02070

There is a patch for Oracle 18c.

I would like to know if there is a patch for this type of error for Oracle 19c.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center