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

RMAN-06716: skipping datafile number; already restored to file string

1 Answers  


ORA-39004: invalid state

1 Answers  


ORA-30456: 'string.string' cannot be refreshed because of insufficient privilege

1 Answers  


RMAN-08549: database name (or lock name space) used for search: string

1 Answers  


ORA-37132: (XSCCOMP07) Incremental aggregation over the dense DIMENSION workspace object is not supported when aggregating a VARIABLE dimensioned by a COMPRESSED COMPOSITE.

1 Answers  






ORA-07218: slkhst: could not perform host operation

1 Answers  


KUP-03005: relative end (number) specified does not match fieldlen(number) for field string

1 Answers  


ORA-27013: skgfqdel: cannot delete an open file

1 Answers  


TNS-00014: INTCTL: error while opening terminal input channel

1 Answers  


ORA-28263: Insufficient memory in global context pool

1 Answers  


TNS-01168: Cannot allocate memory

1 Answers  


ORA-00376: file string cannot be read at this time

1 Answers  


Categories