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-22297: warning: Open LOBs exist at transaction commit time

1 Answers  

---

ORA-02165: invalid option for CREATE DATABASE

1 Answers  

---

ORA-32159: Cannot set prefetch options for a null Type

1 Answers  

---

RMAN-08005: new incarnation of database registered in recovery catalog

1 Answers  

---

NZE-29238: the cryptographic engine could not apply the algorithm

1 Answers  

---

PCC-02023: Found end of file while scanning a PL/SQL statement

1 Answers  

---

NZE-29164: External PKCS #12 wallet is not supported in FIPS mode.

1 Answers  

---

NNO-00314: error changing trace level from number to number, level change ignored

1 Answers  

---

NID-00107: File I/O error on datafile "string" during string operation (number/string)

1 Answers  

---

ORA-19768: USING clause only valid with ENABLE CHANGE TRACKING

1 Answers  

---

IMG-02002: 2FF02 - incorrect average color feature specification

1 Answers  

---

PLS-01452: This function is not part of the ANSI standard

1 Answers  

---