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

DRG-11107: invalid path specification: string

1 Answers  


EXP-00035: QUERY parameter valid only for table mode exports

1 Answers  


ORA-25425: connection lost during rollback

1 Answers  


ORA-23379: connection qualifier "string" is too long

1 Answers  


ORA-24043: destination string uses a reserved name, names with AQ$_ prefix are not valid

1 Answers  






PCC-00142: No EXEC SQL CONTEXT USE statement encountered

1 Answers  


RMAN-06557: unable to restore archived log thread number, sequence number

1 Answers  


NID-00110: Cannot use REVERT and specify a database name at the same time

1 Answers  


DRG-11621: URL store: socket open error for string

1 Answers  


QSM-01011: when heuristic rewrite not set, rewrite hint required

1 Answers  


ORA-16162: Cannot add new standby databases to protected configuration

1 Answers  


ORA-06592: CASE not found while executing CASE statement

1 Answers  


Categories