QSM-01113: HAVING clause of mv, string, is more restrictive
than query



QSM-01113: HAVING clause of mv, string, is more restrictive than query..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-01189: file is from a different RESETLOGS than previous files

1 Answers  


PLS-00372: In a procedure, RETURN statement cannot contain an expression

1 Answers  


NNL-00981: Timeouts, server not responding: number

1 Answers  


DRG-11858: Gopher Server Replies

1 Answers  


ORA-04009: MAXVALUE cannot be made to be less than the current value

1 Answers  






ORA-16754: Resource guard could not activate standby

1 Answers  


ORA-09353: Windows 32-bit Two-Task driver unable to open event semaphore

1 Answers  


NNC-00422: invalid data type name "string"

1 Answers  


ORA-29276: transfer timeout

1 Answers  


TNS-12645: Parameter does not exist.

1 Answers  


ORA-30655: cannot select FOR UPDATE from external organized table

1 Answers  


DRG-11866: Please Try `ftp://' Instead Of `file://'

1 Answers  


Categories