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

ORA-37012: (XSACQUIRE_TIMEOUT) Object workspace object is locked by another user and the WAIT timed out.

1 Answers  


ORA-31091: empty string specified as a SQL name

1 Answers  


ORA-19706: invalid SCN

1 Answers  


ORA-01680: unable to extend LOB segment by string in tablespace string

1 Answers  


ORA-12569: TNS:packet checksum failure

1 Answers  






ORA-32589: unable to drop minimal supplemental logging

1 Answers  


PLS-00369: no choices may appear with choice OTHERS in an exception handler

1 Answers  


RMAN-06429: %s database is not compatible with this version of RMAN

1 Answers  


PCB-00575: PLS-number: string

1 Answers  


ORA-06708: TLI Driver: message receive failure

1 Answers  


ORA-13440: GeoRaster metadata compression type error

1 Answers  


ORA-19603: cannot backup or copy active file with KEEP .. UNRECOVERABLE option

1 Answers  


Categories