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-32575: Explicit column default is not supported for modifying views

1 Answers  


NNO-00623: setting auto-refresh retry interval to number seconds

1 Answers  


ORA-01985: cannot create user as LICENSE_MAX_USERS parameter exceeded

1 Answers  


ORA-25157: Specified block size string is not valid

1 Answers  


ORA-25265: specified signature for a queue which does not support reciever non-repudiation

1 Answers  






ORA-19861: additional backup pieces cannot be validated in this conversation

1 Answers  


NNL-00999: ALIAS LOOP responses received: number

1 Answers  


NNL-00213: No entry with specified index number, try "SHOW SYSTEM_QUERIES"

1 Answers  


ORA-14169: invalid ALTER TABLE MODIFY SUBPARTITION option

1 Answers  


ORA-15113: alias name 'string' refers to a directory

1 Answers  


TNS-12235: TNS:Failure to redirect to destination

1 Answers  


IMG-00606: unable to access image data

1 Answers  


Categories