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-06764: TLI Driver: error reading disconnect

1 Answers  


QSM-02083: mv references PL/SQL function that maintains state

1 Answers  


ORA-12800: system appears too busy for parallel query execution

1 Answers  


RMAN-06028: duplicate operand specified in restore specification: string

1 Answers  


ORA-00360: not a logfile member: string

1 Answers  






NZE-28768: bad magic number

1 Answers  


ORA-07200: slsid: oracle_sid not set.

1 Answers  


ORA-13382: geometry metadata (table:string column:string) not found in spatial network:string

1 Answers  


ORA-31154: invalid XML document

1 Answers  


ORA-14107: partition specification is required for a partitioned object

1 Answers  


NNL-00989: Objects received with no TTL: number

1 Answers  


DRG-10844: index cannot execute this structured predicate efficiently

1 Answers  


Categories