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

NZE-29109: Cannot create private key object.

1 Answers  


ORA-00316: log string of thread string, type string in header is not log file

1 Answers  


ORA-01211: Oracle7 data file is not from migration to Oracle8

1 Answers  


ORA-16539: task element not found

1 Answers  


SQL-02141: Collection descriptor has not been allocated

1 Answers  






ORA-12152: TNS:unable to send break message

1 Answers  


ORA-31470: asynchronous change tables must contain the RSID$ column

1 Answers  


ORA-29366: invalid CONSUMER_GROUP argument specified

1 Answers  


PLS-00360: cursor declaration without body needs return type

1 Answers  


ORA-02033: a cluster index for this cluster already exists

1 Answers  


ORA-07610: $GETJPIW failed in retrieving the user's MAC priviledges

1 Answers  


NZE-28754: object storage failure

1 Answers  


Categories