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


QSM-01112: WHERE clause of mv, string, is more restrictive
than query



QSM-01112: WHERE clause of mv, string, is more restrictive than query..

Answer / guest

Cause: The materialized view contains a selection condition
in the WHERE 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

ORA-12622: TNS:event notifications are not homogeneous

1 Answers  


LPX-00265: read failed from to host ~s

1 Answers  


ORA-17619: max number of processes using I/O slaves in a instance reached

1 Answers  


ORA-16014: log string sequence# string not archived, no available destinations

1 Answers  


ORA-26078: file "string" is not part of database being loaded

1 Answers  






PCC-00087: EXEC SQL TYPE statement not allowed for this host language

1 Answers  


RMAN-08023: channel string: restored backup piece string

1 Answers  


IMG-00001: unable to initialize Oracle interMedia environment

1 Answers  


ORA-01268: invalid TEMPFILE clause for alter of permanent TABLESPACE

1 Answers  


QSM-02142: COUNT(*) is not present in the select list

1 Answers  


ORA-38756: Flashback is already turned off for this tablespace.

1 Answers  


ORA-23425: invalid materialized view identifier string

1 Answers  






Categories