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-04076: invalid NEW or OLD specification

1 Answers  

---

ORA-00314: log string of thread string, expected sequence# string doesn't match string

1 Answers  

---

ORA-26040: Data block was loaded using the NOLOGGING option

1 Answers  

---

ORA-12425: cannot apply policies or set authorizations for system schemas

1 Answers  

---

ORA-02026: missing LINK keyword

1 Answers  

---

---

ORA-32400: cannot use object id columns from materialized view log on "string"."string"

1 Answers  

---

ORA-27215: skgfgsmcs: sbtinfo2 returned unknown file

1 Answers  

---

ORA-36200: (XSAGGR34) AGGREGATE operator string requires a WEIGHTBY clause, but ARGS variable workspace object did not specify one.

1 Answers  

---

ORA-01492: LIST option not valid

1 Answers  

---

O2U-00212: An error occurred for which no message is available

1 Answers  

---

ORA-01764: new update value of join is not guaranteed to be unique

1 Answers  

---

ORA-03214: File Size specified is smaller than minimum required

1 Answers  

---