QSM-01092: mjv tries to rewrite a semi-join and primary key
or rowid missing



QSM-01092: mjv tries to rewrite a semi-join and primary key or rowid missing..

Answer / guest

Cause: Materialized join view tries to rewrite a semi-join
(IN sub-query) and the primary keys or rowids of left tables
of semi-joins are missing from MJV.

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-04045: errors during recompilation/revalidation of string.string

1 Answers  


ORA-40221: maximum target cardinality exceeded

1 Answers  


AMD-00118: output file "string" already exists

1 Answers  


PLS-00112: end-of-line in quoted identifier

1 Answers  


PCC-00115: Array required here

1 Answers  






RMAN-11000: message number number not found in recovery manager message file

1 Answers  


ORA-27071: unable to seek to desired position in file

1 Answers  


LPX-00214: CDATA section did not end in "]]>"

1 Answers  


ORA-34350: (MXDSS06) string is an open analytic workspace.

1 Answers  


ORA-12015: cannot create a fast refresh materialized view from a complex query

1 Answers  


PLS-00327: "string" is not in SQL scope here

1 Answers  


ORA-24460: Native Net Internal Error

1 Answers  


Categories