QSM-01113: HAVING clause of mv, string, is more restrictive
than query
- 1 Answers
- 2128 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-14167: only one subpartition may be moved
ORA-31475: redo log catalog contains no metadata for the source table
ORA-32635: not a single cell reference predicate
ORA-39102: Timeout before master process string finished initialization. Master error:
ORA-00363: log is not the archived version
ORA-14643: Hakan factor mismatch for tables in ALTER TABLE EXCHANGE PARTITION
DRG-12601: invalid user datastore procedure name: string
ORA-19904: test recovery not allowed for datafile string
TNS-00022: INTCTL: missing CMANAGER_NAME in INTCHG.ORA
ORA-04934: unable to obtain the current sequence number
KUP-11001: files not from the same unload operation
DRG-11851: Cache Related Warning
Oracle Errors 
