QSM-02106: mv uses a filter condition in the WHERE or HAVING
clause



QSM-02106: mv uses a filter condition in the WHERE or HAVING clause..

Answer / guest

Cause: The capability in question is not supported when the
materialized view includes a filter condition in the WHERE
or HAVING clause.

Action: Re-phrase the query to avoid the use of filter
conditions in the WHERE or HAVING clauses.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01512: error renaming log file string - new file string not found

1 Answers  


TNS-12532: TNS:invalid argument

4 Answers  


ORA-25472: maximum open iterators exceeded

1 Answers  


ORA-00203: using the wrong controlfiles

1 Answers  


ORA-01205: not a data file - type number in header is string

1 Answers  






ORA-27465: invalid value string for attribute string

1 Answers  


NZE-29017: The premaster secret length is incorrect.

1 Answers  


ORA-00312: online log string thread string: 'string'

1 Answers  


KUP-04041: error generating full file name for string in string

1 Answers  


IMG-00861: assert failure, inconsistency in area merge operation

1 Answers  


ORA-13224: zero tolerance specified for layer in USER_SDO_GEOM_METADATA

1 Answers  


IMG-00553: invalid rotate value

1 Answers  


Categories