QSM-01112: WHERE clause of mv, string, is more restrictive
than query
- 1 Answers
- 3452 Views
- I also Faced
- E-Mail Answers
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 |
NZE-29237: the cryptographic engine could not finish the algorithm
ORA-03292: Table to be truncated is part of a cluster
TNS-01165: Spawn alias has no program name set in it
ORA-15091: operation incompatible with open handle in this session
ORA-24183: invalid transformation
ORA-36178: (XSAGGR01) To be used with AGGREGATE, AGGMAP workspace object must be declared with the AGGMAP command.
RMAN-06497: WARNING: controlfile is not current, controlfile autobackup skipped
ORA-03122: attempt to close ORACLE-side window on user side
DRG-50608: unexpected end of data
ORA-02291: integrity constraint (string.string) violated - parent key not found
LPX-00209: PI names starting with XML are reserved
ORA-02199: missing DATAFILE/TEMPFILE clause
Oracle Errors 
