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

RMAN-08031: released channel: string

1 Answers  


NNO-00300: no listen addresses specified, at least one is required

1 Answers  


ORA-15116: invalid combination of ALTER DISKGROUP options

1 Answers  


ORA-22885: cannot get REF to a non-persistent object

1 Answers  


RMAN-06545: "string" is an invalid response - please re-enter.

1 Answers  






ORA-07614: $CHANGE_CLASS failed in retrieving the user's process label

1 Answers  


LPX-00218: invalid character ~1u ('~2c')

1 Answers  


QSM-01014: top level operator in WHERE clause of the query is an OR

1 Answers  


ORA-16180: number processes specified for MAX_PARALLEL_SERVERS is too small

1 Answers  


DRG-50901: text query parser syntax error on line string, column string

1 Answers  


ORA-01165: MAXDATAFILES may not exceed string

1 Answers  


QSM-01025: materialized view, string, not found

1 Answers  


Categories