QSM-01100: containment check failed for mv, string

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2540


ORA-16627: No standby databases support the overall protection mode.

3744


IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2492


ORA-26028: index string.string initially in unusable state

3605


ORA-26029: index string.string partition string initially in unusable state

1910






invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3104


ORA-16516: The current state is invalid for the attempted operation.

8410


IMP-00064: Definition of LOB was truncated by export

6120


NZE-28868: Peer certificate chain check failed.

2465


ORA-26030: index string.string had string partitions made unusable due to:

1715


ORA-26082: load of overlapping segments on table string.string is not allowed

1541


NZE-28890: Entrust Login Failed

1585


ORA-26032: index string.string loading aborted after string keys

1830


ORA-26079: file "string" is not part of table string.string

1700


IMG-02003: 2FF03 - incorrect color histogram feature specification

1409