Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

TNS-12531: TNS:cannot allocate memory

1 Answers  


ORA-24273: translation text is required if translation type is T or S

1 Answers  


ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML

1 Answers  


ORA-13515: Error encountered during Database Usage Statistics capture

1 Answers  


ORA-35095: (QFSVNS01) One or more imported values of fixed-width dimension workspace object have been truncated.

1 Answers  






PLS-00431: bulk SQL attributes must use a single index

1 Answers  


LPX-00237: invalid condition section keyword, must be INCLUDE or IGNORE

1 Answers  


PCC-00066: Userid only used when SQLCHECK = FULL, userid ignored.

1 Answers  


ORA-38737: Expected sequence number string doesn't match string

1 Answers  


NID-00140: Specified database name string does not match previous name used string

1 Answers  


NID-00132: CHECKPOINT_CHANGE# in datafile "string": string in the future of controlfile: string

1 Answers  


ORA-29840: indextype and implementation type are not in same schema

1 Answers  






Categories