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


QSM-01074: materialized view, string, and query have
different no of joins between tables, string



QSM-01074: materialized view, string, and query have different no of joins between tables, string..

Answer / guest

Cause: Query rewrite may not be possible if the query has
some joins that the materialized view does not have between
the same pair of tables.

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-50401: failed to retrieve fuzzy match candidates from db: string

1 Answers  


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

1 Answers  


ORA-26049: Unscoped REF column has non-existent table name.

1 Answers  


RMAN-20031: resync not started

1 Answers  


ORA-12993: tablespace 'string' is offline, cannot drop column

1 Answers  






ORA-13500: SYSAUX DATAFILE clause specified more than once

1 Answers  


ORA-02773: Invalid maximum client wait time

1 Answers  


ORA-16793: Logical Standby Database Guard is unexpectedly OFF

1 Answers  


ORA-28275: Multiple mappings for user nickname to LDAP distinguished name exist.

1 Answers  


IMG-00910: allocation of basic data structure failed

1 Answers  


ORA-29831: operator binding not found

1 Answers  


LSX-00143: element "~S" must have type or ref

1 Answers  






Categories