QSM-01113: HAVING clause of mv, string, is more restrictive
than query
- 1 Answers
- 2447 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The materialized view contains a selection condition
in the 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 |
ORA-09709: soacon: failed to accept a connection.
ORA-19758: failed to enable/disable block change tracking: out of SGA memory
ORA-22292: Cannot open a LOB in read-write mode without a transaction
RMAN-06565: WARNING: string: sqlcode number was caught, automatic retry #number
ORA-25200: invalid value string, QUEUE_NAME should be [SCHEMA.]NAME
DRG-50922: PL/SQL execution failed for string
ORA-06761: TLI Driver: error sending orderly release
RMAN-06290: Report of database schema
KUP-04071: record discarded from file string
ORA-27201: skgfpcm: sbtpccommit returned error
ORA-19028: Invalid ADT parameter passed to toObject() function
ORA-12549: TNS:operating system resource quota exceeded
Oracle Errors 
