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-00057: maximum number of temporary table locks exceeded

1 Answers  


ORA-32134: Cannot assign LOBs

1 Answers  


LPX-00011: In line ~1u of ~2s [general entity ~3S]:

1 Answers  


ORA-12045: invalid ALTER MATERIALIZED VIEW LOG option

1 Answers  


AMD-00125: dimension #string: analytic workspace column level dimension not specified

1 Answers  






PCC-02326: illegal structure reference operation

1 Answers  


ORA-00040: active time limit exceeded - call aborted

1 Answers  


DRG-11605: URL store: document specified by string not found

1 Answers  


ORA-30742: cannot grant SELECT privilege WITH HIERARCHY OPTION on this object

1 Answers  


ORA-31213: DBMS_LDAP: PL/SQL - Invalid LDAP mod option.

1 Answers  


DRG-11730: relation does not exist

1 Answers  


TNS-12585: TNS:data truncation

1 Answers  


Categories