Answer / guest

Cause: A table in a materialized view is an anchor, (a) if
it is not joined to any other table or (b) joined to other
tables but each of its joins is either lossy or lossless
with the above table being child-side table. If an anchor
which is present in the materialized view is not found in
the query, then query rewrite will not take place.

Action: none

Please add more information about this Error

ORA-02195: Attempt to create string object in a string tablespace

1 Answers  

---

ORA-30100: internal error [number]

1 Answers  

---

ORA-04082: NEW or OLD references not allowed in table level triggers

2 Answers   Satyam,

---

ORA-38494: column in the table alias and an attribute have matching names

1 Answers  

---

NNL-00507: Shows, sets, or cancels the time when an auto-refresh query is next issued

1 Answers  

---

SQL*Loader-00435: invalid constant value string for nested table column string

1 Answers  

---

PCC-02421: This host variable requires the use of an indicator variable

1 Answers  

---

NNL-01053: Request processing enabled: string

1 Answers  

---

RMAN-06741: database name is "string" and DBID is string

1 Answers  

---

ORA-31076: required attribute "string" not specified

1 Answers  

---

ORA-22812: cannot reference nested table column's storage table

1 Answers  

---

PROC-00021: Maximum permitted depth of the OCR tree is reached

1 Answers  

---