12c: Query Rewrite Not Happening With Message Code QSM-01113
Last updated on DECEMBER 06, 2016
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
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
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