Answer / guest

Cause: If there is a semi join in the query, then Query
Rewrite will create (select distinct <pk-list>, <ref-col>
from mjv) where <pk-list> is the list of rowids/pk of all
mjv tables that don't correspond to a right side of a
semi-join and <ref-col> are their columns. Query Rewrite
will not occur if a join from the materialized view cannot
match the semi-join from the query.

Action: none

Please add more information about this Error

ORA-02789: Maximum number of files reached

1 Answers  

---

ORA-26677: Streams downstream capture process string cannot proceed

1 Answers  

---

ORA-22817: subquery not allowed in the default clause

1 Answers  

---

TNS-12635: No authentication adapters available

1 Answers  

---

ORA-01578: ORACLE data block corrupted (file # string, block # string)

1 Answers  

---

---

ORA-02849: Read failed because of an error

1 Answers  

---

PLS-00498: illegal use of a type before its declaration

1 Answers  

---

ORA-30031: the suspended (resumable) statement has been aborted

1 Answers  

---

QSM-01100: containment check failed for mv, string

1 Answers  

---

ORA-31690: Process name buffer size must be specified and must be greater than 0.

1 Answers  

---

ORA-01694: max # extents (string) reached in lob segment string.string partition string

1 Answers  

---

ORA-24079: invalid name string, names with AQ$_ prefix are not valid for string

1 Answers  

---