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

PCC-02205: Parser error at line number, column number, file string:

1 Answers  


ORA-30155: An I/O Error occured during an OCIFile function call

1 Answers  


ORA-28108: circular security policies detected

1 Answers  


ORA-07443: function string not found

1 Answers  


ORA-01864: the date is out of range for the current calendar

1 Answers  


ORA-30772: opaque types do not have default constructors

1 Answers  


RMAN-02006: script line too long

1 Answers  


ORA-24396: invalid attribute set in server handle

1 Answers  


RMAN-06448: uncataloged proxy copy

1 Answers  


ORA-25468: column name not specified for alias: string

1 Answers  


TNS-04234: Trace Assistant WARNING: won't decode TTC

1 Answers  


ORA-00321: log string of thread string, cannot update log file header

1 Answers  


Categories