QSM-01093: anti-join marker not found in materialized join view



QSM-01093: anti-join marker 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

LSX-00018: invalid schema context

1 Answers  


ORA-40273: invalid model type string for Adaptive Bayes Network algorithm

1 Answers  


ORA-28666: option not allowed for an index on UROWID column(s)

1 Answers  


ORA-01270: %s operation is not allowed if STANDBY_PRESERVES_NAMES is true

1 Answers  


ORA-08119: The new initrans will make the index too big

1 Answers  






ORA-01771: illegal option for a clustered table

1 Answers  


RMAN-08005: new incarnation of database registered in recovery catalog

1 Answers  


LSX-00168: referring form of "~S" must NOT occur at the top level

1 Answers  


ORA-19597: file string blocksize string does not match set blocksize of string

1 Answers  


ORA-23443: missing template parameter

1 Answers  


PCB-00230: Indicator table size must not be less than its host variable

1 Answers  


ORA-33022: (XSAGDNGL10) The measure dimension workspace object must be a TEXT or ID base dimension that does not dimension AGGMAP workspace object, but is in the same analytic workspace.

1 Answers  


Categories