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
2787 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-13786: missing SQL text of statement object "string" for tuning task "string"

1 Answers

LPX-00229: input source is empty

1 Answers

QSM-00509: invalid parameter

1 Answers

ORA-19563: %s header validation failed for file string

1 Answers

ORA-13856: Service name must be specified

1 Answers

PCC-02329: found reference to undeclared function

1 Answers

DRG-12406: invalid CTX EXEC tag attribute (string)

1 Answers

ORA-06440: ssaio: the asynchronous read returned incorrect number of bytes

1 Answers

ORA-08457: syntax error in SEPARATE CHARACTER option of SIGN clause

1 Answers

RMAN-08528: channel string: proxy copy complete, elapsed time: string

1 Answers

ORA-29268: HTTP client error string

1 Answers

DRG-12230: special section name must be one of string

1 Answers

For more Oracle Errors Interview Questions Click Here