QSM-01112: WHERE clause of mv, string, is more restrictive
than query
- 1 Answers
- 3120 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 |
ORA-28579: network error during callback from external procedure agent
ORA-12582: TNS:invalid operation
ORA-26086: direct path does not support triggers
ORA-19757: could not resize change tracking file to string blocks
ORA-28554: pass-through SQL: out of cursors
ORA-09989: attempt to use invalid skgmsdef struct pointer
ORA-31687: error creating worker process string with worker id string
ORA-01545: rollback segment 'string' specified not available
RMAN-06154: validation succeeded for datafile copy
ORA-08230: smscre: failed to allocate SGA
ORA-32695: HTI: Not enough memory
ORA-31190: Resource string is not a version-controlled resource
Oracle Errors 
