QSM-01112: WHERE clause of mv, string, is more restrictive
than query
- 1 Answers
- 3089 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 |
SQL*Loader-00422: constant element count of number for column string is greater than maximum, number
ORA-16744: The DG_CONFIG list of LOG_ARCHIVE_CONFIG parameter is full.
ORA-28042: Server authentication failed
ORA-12638: Credential retrieval failed
EXP-00068: tablespace string is offline
DRG-12013: This method has already been performed - repeat operation?
ORA-28557: unknown string for database link to non-Oracle system
QSM-01051: no support for rollup when a window function is present on the column
ORA-28238: no seed provided
RMAN-08058: replicating controlfile
ORA-01088: cannot shut down ORACLE while active processes exist
ORA-08008: another instance is mounted with USE_ROW_ENQUEUES = string
Oracle Errors 
