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-12726: unmatched bracket in regular expression

1 Answers  


DRG-11811: Multiple Choices

1 Answers  


PCC-02152: Unable to open file string to display or list the source line number

1 Answers  


NZE-28874: SSL: I/O closed - override goodbye kiss

1 Answers  


ORA-02352: file truncated error

1 Answers  






ORA-14268: subpartition 'string' of the partition resides in offlined tablespace

1 Answers  


NZE-29007: Bad Clear Key Length when using SSL 2.0

1 Answers  


QSM-02132: agg(expr) requires correspondng COUNT(expr) function

1 Answers  


ORA-02420: missing schema authorization clause

1 Answers  


RMAN-01008: the bad identifier was: string

1 Answers  


ORA-01511: error in renaming log/data files

1 Answers  


ORA-30017: segment 'string' is not supported in string Undo Management mode

1 Answers  


Categories