QSM-01049: semi-join check failed for materialized view, string



QSM-01049: semi-join check failed for materialized view, string..

Answer / guest

Cause: If there is a semi join in the query, then Query
Rewrite will create (select distinct <pk-list>, <ref-col>
from mjv) where <pk-list> is the list of rowids/pk of all
mjv tables that don't correspond to a right side of a
semi-join and <ref-col> are their columns. Query Rewrite
will not occur if a join from the materialized view cannot
match the semi-join from the query.

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

PLS-00351: Not logged onto database 'string'

1 Answers  


ORA-25263: no message in queue string.string with message ID string

1 Answers  


ORA-31676: illegal value for number of workers, string

1 Answers  


ORA-07259: spdcr: exec error, detached process failed in startup.

1 Answers  


NNC-00051: message content error

1 Answers  






ORA-02285: duplicate START WITH specifications

1 Answers  


ORA-32312: cannot refresh a secondary materialized view "string"."string"

1 Answers  


SQL*Loader-00427: a field condition references a non-scalar field or a LOB field string

1 Answers  


ORA-02263: need to specify the datatype for this column

1 Answers  


NNL-00833: Fastest delete processing time: string

1 Answers  


ORA-40262: NMF: number of features not between [1, string]

1 Answers  


LSX-00171: missing required sub-element "~S"

1 Answers  


Categories