Database Administration (MOSC)

MOSC Banner

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

in Database Administration (MOSC) 3 commentsAnswered

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center