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-11625: MAXURLS * URLSIZE must be less than string

1 Answers  


TNS-00083: (USER or ADMIN) in the argument field

1 Answers  


PLS-00322: declaration of a constant 'string' must contain an initialization assignment

1 Answers  


ORA-07431: fork failed

1 Answers  


ORA-38497: Expression Filter index does not exist

1 Answers  






PLS-00639: NCHAR/NVARCHAR2 cannot be byte length semantics

1 Answers  


TNS-00028: INTCTL: Could not resolve Connection Manager's name/address

1 Answers  


PLS-00330: invalid use of type name or subtype name

1 Answers  


TNS-12668: Dedicated server: outbound protocol does not support proxies

1 Answers  


CLSS-02200: Received node deletion request for active node string.

1 Answers  


LPX-00004: internal error "~s"

1 Answers  


ORA-00821: Specified value of sga_target is too small, needs to be at least stringM

1 Answers  


Categories