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

ORA-12835: No instances are active in the GLOBAL_VIEW_ADMIN_GROUP

1 Answers  


ORA-12429: label list range exceeded

1 Answers  


RMAN-08047: channel string: starting compressed incremental level string datafile backupset

1 Answers  


NID-00129: Invalid DBID for datafile "string", expecting number, found number

1 Answers  


ORA-00327: log string of thread string, physical size string less than needed string

1 Answers  






ORA-07680: sou2os: another call to ORACLE currently executing

1 Answers  


ORA-27416: BYDAY= clause in repeat interval contains an invalid weekday

1 Answers  


RMAN-12020: error on step filtered for normal output string

1 Answers  


ORA-37060: (XSMCSESS08) number is not a valid custom member in dimension workspace object.

1 Answers  


LSX-00266: missing required attribute "~S"

1 Answers  


ORA-09292: sksabln: unable to build archive file name

1 Answers  


ORA-19765: mount id string does not match mount id string in control file

1 Answers  


Categories