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

DRG-50942: errors: stringstring

1 Answers  


ORA-24343: user defined callback error

1 Answers  


TNS-00211: Total Active Pumps : number

1 Answers  


RMAN-06073: file header is corrupt for datafile string

1 Answers  


KUP-03001: fatal error during library cache pre-loading

1 Answers  






ORA-02754: osnfsmmap: cannot change shared memory inheritence

1 Answers  


PLS-00155: Only a function may be a MAP, ORDER or CONSTRUCTOR method.

1 Answers  


NNL-00526: Starts a server using a non-standard executable and optional arguments

1 Answers  


ORA-12200: TNS:could not allocate memory

1 Answers  


ORA-33247: (CRENAME03) %K is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.

1 Answers  


LPX-00306: inputed string ended with no corresponding closing '}'

1 Answers  


ORA-14401: inserted partition key is outside specified partition

1 Answers  


Categories