Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


QSM-01113: HAVING clause of mv, string, is more restrictive
than query



QSM-01113: HAVING clause of mv, string, is more restrictive than query..

Answer / guest

Cause: The materialized view contains a selection condition
in the HAVING clause that is more restrictive than the
corresponding selection condition in the request query.

Action: Change the selection criteria in the request query
to be at least as restrictive as the selection criteria in
the materialized view, or drop and recreate the materialized
view using less restrictive selection criteria.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNL-00262: Request forwarding is currently disabled

1 Answers  


ORA-01255: cannot shutdown - file string in recovery manager backup

1 Answers  


ORA-13459: GeoRaster metadata SRS error

1 Answers  


ORA-06951: Operating system call error

1 Answers  


ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled

1 Answers  






AUD-00809: ORDSpeechIndex: unable to ALTER REBUILD internal Text index

1 Answers  


ORA-06545: PL/SQL: compilation error - compilation aborted

1 Answers  


RMAN-06513: copy will never be obsolete

1 Answers  


ORA-30451: internal error

1 Answers  


DRG-11445: rowid value is invalid: string

1 Answers  


ORA-00102: network protocol string cannot be used by dispatchers

1 Answers  


TNS-00091: * Navigator (or navgatr) - will ask the Navigator only

1 Answers  






Categories