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-24292: no more tables permitted in this sorted hash cluster

1 Answers  

---

ORA-23292: The constraint does not exist

1 Answers  

---

ORA-12164: TNS:Sqlnet.fdf file not present

1 Answers  

---

ORA-29286: internal error

1 Answers  

---

TNS-12516: TNS:listener could not find available handler with matching protocol stack

1 Answers  

---

ORA-02309: atomic NULL violation

1 Answers  

---

ORA-00711: new tablespace name is invalid

1 Answers  

---

LPX-00202: could not open "~s" (error ~u)

1 Answers  

---

TNS-00121: Missing CMANAGER_NAME in INTCHG.ORA

1 Answers  

---

ORA-38423: Attribute set created from an ADT may not be extended.

1 Answers  

---

LRM-00114: error when processing from command line

1 Answers  

---

ORA-27045: unable to close the file

1 Answers   Aomi,

---