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

PLS-00315: Implementation restriction: unsupported table index type

1 Answers  


ORA-25290: Cannot complete operation on queue string with existing messages

1 Answers  


RMAN-08051: cataloged archive log

1 Answers  


ORA-04005: INCREMENT must be less than MAXVALUE minus MINVALUE

1 Answers  


LFI-00134: Unable to protect a file for an append operation.

1 Answers  


ORA-31028: Resource metadata length string exceeded maximum length string

1 Answers  


ORA-32619: incorrect use of MODEL ITERATION_NUMBER

1 Answers  


RMAN-08132: WARNING: cannot refresh aged file list

2 Answers  


ORA-06932: CMX: error in local name

1 Answers  


DRG-12225: this type of section cannot be added to this section group

1 Answers  


ORA-25143: default storage clause is not compatible with allocation policy

1 Answers  


NNC-00420: operation not allowed

1 Answers  


Categories