Answer Posted / guest

Cause: The materialized view contains a selection condition
in the WHERE or HAVING clause that is more restrictive than
the corresponding selection condition in the request query.

Action: Change the selection criteria in the request query
to be at least as restrictive as the selection criteria in
the materialized view, or drop and recreate the materialized
view using less restrictive selection criteria.

Please add more information about this Error

NZE-28890: Entrust Login Failed

1863

---

ORA-26030: index string.string had string partitions made unusable due to:

1926

---

ORA-26028: index string.string initially in unusable state

3849

---

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3139

---

ORA-26082: load of overlapping segments on table string.string is not allowed

1755

---

IMP-00064: Definition of LOB was truncated by export

6396

---

Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

2729

---

NZE-28868: Peer certificate chain check failed.

2787

---

RMAN-05017: no copy of datafile number found to recover

2399

---

ORA-26084: direct path context already finished

1937

---

ORA-16626: failed to enable specified object

2202

---

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2217

---

ORA-26094: stream format error: input column overflow

2785

---

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2862

---

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2688

---