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
2719 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-23427: deferred purge queue argument string out of range

1 Answers

NZE-28790: NLS string open failure

1 Answers

ORA-24502: codepoint length overflows

1 Answers

DRG-50940: parser not parsed

1 Answers

RMAN-10029: unexpected return code number from PL/SQL execution

1 Answers

NNL-00257: Server-generated requests currently require authoritative answers

1 Answers

ORA-36814: (XSTBLFUNC07) The datatype of the column used in the ROW2CELL clause of a LIMITMAP must be RAW(16).

1 Answers

RMAN-06909: WARNING: parallelism require Enterprise Edition

2 Answers

TNS-03508: Failed to create address string

1 Answers

ORA-25128: No insert/update/delete on table with constraint (string.string) disabled and validated

1 Answers

ORA-00710: new tablespace name is the same as the old tablespace name

1 Answers

ORA-01080: error in shutting down ORACLE

1 Answers

For more Oracle Errors Interview Questions Click Here