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

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

Question Posted / guest

1 Answers
2881 Views
I also Faced
E-Mail Answers

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

TNS-01034: Uptime number days number hr. number min. number sec

1 Answers

ORA-25018: conflicting trigger string already exists

1 Answers

NNO-00311: invalid listen address list

1 Answers

DRG-11843: Gateway Timeout

1 Answers

ORA-13010: an invalid number of arguments has been specified

1 Answers

ORA-32009: cannot reset the memory value for instance string from instance string

1 Answers

ORA-25426: remote instance does not support shared dblinks

1 Answers

ORA-02252: check constraint condition not properly ended

1 Answers

ORA-14311: Expecting VALUES LESS THAN or AT clause

1 Answers

ORA-06510: PL/SQL: unhandled user-defined exception

1 Answers

ORA-14065: ALLOCATE STORAGE may not be specified for a partitioned table

1 Answers

ORA-01757: Must specify an object number

1 Answers

For more Oracle Errors Interview Questions Click Here