QSM-01094: outer-join filter not found in materialized join view



QSM-01094: outer-join filter not found in materialized join view..

Answer / guest

Cause: Materialized join view has outer join while the query
inner join. For rewrite to succeed MV must have an anti-join
marker like the rowid or primary key of the right tables of
outer join

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-02022: remote statement has unoptimized view with remote object

1 Answers  


TNS-01402: TYPE: string

1 Answers  


ORA-06538: statement violates string RESTRICT_REFERENCES pragma

1 Answers  


ORA-14407: partitioned table contains subpartitions in a different tablespace

1 Answers  


ORA-29537: class or resource cannot be created or dropped directly

1 Answers  






ORA-31415: change set string does not exist

1 Answers  


NNO-00152: warning: hint count number exceeds maximum of number, first number will be loaded

1 Answers  


PROT-00016: Internal Error

1 Answers  


SQL*Loader-00628: Character set conversion error.

1 Answers  


NNL-00543: [show] version [<server_list>] : show the name and version of one or more Names servers

1 Answers  


ORA-30394: source statement identical to the destination statement

1 Answers  


NNL-00547: Displays rename request statistics

1 Answers  


Categories