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-36954: (XSFCAST24) The cycle number must be between 1 and number. You specified number.

1 Answers  

---

ORA-25425: connection lost during rollback

1 Answers  

---

PLS-00551: character set ANY_CS is only allowed on a subprogram parameter

1 Answers  

---

ORA-31218: DBMS_LDAP: PL/SQL - Invalid LDAP deleteoldrdn.

1 Answers  

---

ORA-01624: log string needed for crash recovery of instance string (thread string)

1 Answers  

---

ORA-02402: PLAN_TABLE not found

1 Answers  

---

ORA-34021: (MSCGADD04) You must specify a partition when maintaining PARTITION TEMPLATE workspace object.

1 Answers  

---

ORA-16067: activation identifier mismatch in archive log string

1 Answers  

---

DRG-11102: assigned lexer can not operate on string language setting

1 Answers  

---

DRG-11811: Multiple Choices

1 Answers  

---

NNL-00521: Shows or sets the server's system query forwarding requirements

1 Answers  

---

NZE-28832: invalid data unit format

1 Answers  

---