QSM-01098: mv string clause more restrictive than query
string clause
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 |
PCB-00006: Userid only used when SQLCHECK=FULL, userid ignored.
ORA-02397: exceeded PRIVATE_SGA limit, you are being logged off
ORA-14117: partition resides in offlined tablespace
SQL*Loader-00100: Syntax error on command-line
ORA-01554: out of transaction slots in transaction tables
ORA-01030: SELECT ... INTO variable does not exist
ORA-38504: this operator not allowed with the configured attribute set
PLS-00494: coercion into multiple record targets not supported
NID-00138: Block verification failed for datafile string (number)
EXP-00040: Dump file and log file must be different
NNL-00953: Cache lookup exact matches: number
PCC-00086: Source file string has zero length