12c: Query Rewrite Not Happening With Message Code QSM-01113 (Doc ID 2158324.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

After upgrading the database to 12c, one of the query is not rewriting to the MV, but this was rewriting in 11g.

The "dbms_mview.explain_rewrite" package produces the following output in 12c:
QSM-01113: HAVING clause of mv, <mv_name>, is more restrictive than query

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms