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
2884 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

ORA-16754: Resource guard could not activate standby

1 Answers

ORA-27008: function called with invalid file structure

1 Answers

ORA-34141: (MXCGPUT00) You cannot use the ASSIGN keyword with DIMENSION workspace object.

1 Answers

ORA-06120: NETTCP: network driver not loaded

1 Answers

DRG-10709: this preference is referenced by string and cannot be dropped

1 Answers

ORA-28261: CURRENT_USER can not be used in PLSQL Definer's Right procedure.

1 Answers

ORA-14124: duplicate REVERSE clause

1 Answers

RMAN-10027: could not locate network layer context

1 Answers

ORA-07626: smsget: sga already mapped

1 Answers

ORA-15025: could not open disk 'string'

1 Answers

ORA-01908: EXISTS keyword expected

1 Answers

ORA-01561: failed to remove all objects in the tablespace specified

1 Answers

For more Oracle Errors Interview Questions Click Here