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

QSM-02133: agg(expr) requires correspondng MIN(expr) function

1 Answers  

---

PCC-00102: FOR UPDATE is an Oracle extension

1 Answers  

---

ORA-31219: DBMS_LDAP: PL/SQL - Invalid LDAP notypes.

1 Answers  

---

RMAN-06469: could not translate corruption list

1 Answers  

---

ORA-39503: failed to notify CRS of a Startup/Shutdown event [number] (ignored)

1 Answers  

---

ORA-40272: apply rules prohibited for this model mode

1 Answers  

---

NID-00101: LOGFILE (string) not accessible

1 Answers  

---

ORA-27024: skgfqsbi: sbtinit2 returned error

1 Answers  

---

RMAN-08103: channel string: could not locate backup piece: string

1 Answers  

---

NZE-29237: the cryptographic engine could not finish the algorithm

1 Answers  

---

ORA-10652: Object has on-commit materialized views

1 Answers  

---

ORA-07454: queue timeout, string second(s), exceeded

1 Answers  

---