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

IMG-00872: unsupported image model

1 Answers  


TNS-01045: %s(Not Registered) has string service handler(s)

1 Answers  


ORA-02351: internal error: string

1 Answers  


ORA-30503: system triggers cannot have a REFERENCING clause

1 Answers  


SQL-02150: Encountered zero length in ANSI dynamic SET statement

1 Answers  






ORA-30448: internal data of the advisor repository is inconsistent

1 Answers  


RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status

1 Answers  


ORA-39305: specified schema "string" does not exist

1 Answers  


ORA-16090: archive log to be replaced not created by managed standby process

1 Answers  


RMAN-05009: Block Media Recovery requires Enterprise Edition

1 Answers  


ORA-06431: ssaio: Invalid Block number

1 Answers  


ORA-31159: XML DB is in an invalid state

1 Answers  


Categories