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


QSM-01100: containment check failed for mv, string



QSM-01100: containment check failed for mv, string..

Answer / guest

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

ORA-03213: Invalid Lob Segment Name for DBMS_SPACE package

1 Answers  


ORA-13610: The directive string does not exist for task string.

1 Answers  


PLS-01507: DROP is non-ANSI

1 Answers  


TNS-12168: TNS:Unable to contact LDAP Directory Server

1 Answers  


RMAN-08021: channel string: restoring controlfile

1 Answers  






ORA-27190: skgfrd: sbtread2 returned error

1 Answers  


SQL*Loader-00200: FORMAT clause should not be present - flat data files only

1 Answers  


NZE-29107: Cannot create PKCS #12 wallet.

1 Answers  


ORA-12028: materialized view type is not supported by master site string

1 Answers  


ORA-29505: AS keyword is invalid in CREATE JAVA CLASS or RESOURCE

1 Answers  


ORA-38446: Error with embedded ADT "string" in the attribute set.

1 Answers  


TNS-12526: TNS:listener: all appropriate instances are in restricted mode

1 Answers  






Categories