Last updated on DECEMBER 06, 2016
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 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
Million Knowledge Articles and hundreds of Community platforms