Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-02782: Both read and write functions were not specified

1 Answers  


ORA-24347: Warning of a NULL column in an aggregate function

1 Answers  


ORA-03291: Invalid truncate option - missing STORAGE keyword

1 Answers  


ORA-06306: IPA: Message write length error

1 Answers  


ORA-08231: smscre: unable to attach to SGA

1 Answers  






ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

2 Answers  


DRG-50919: NEAR operand not a phrase, equivalence or another NEAR expression

1 Answers  


ORA-00094: %s requires an integer value

1 Answers  


ORA-13142: invalid PROXIMITY window definition

1 Answers  


ORA-03282: missing ALLOCATE EXTENT option

1 Answers  


RMAN-12012: multiple records for string parallelism found in catalog

1 Answers  


ORA-31199: Warning in processing file string

1 Answers  






Categories