Answer Posted / guest

Cause: A fine grain access control procedure has applied a
non-null policy to the query for the materialized view.

Action: In order for the materialized view to work
correctly, any fine grain access control procedure in effect
for the query must return a null policy when the
materialized view is being created or refreshed. This may be
done by ensuring that the usernames for the creator, owner,
and invoker of refresh procedures for the materialized view
all receive a null policy by the user-written fine grain
access control procedures.

Please add more information about this Error

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3368

---

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...

2585

---

ORA-26094: stream format error: input column overflow

2785

---

ORA-16627: No standby databases support the overall protection mode.

3963

---

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

3139

---

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2720

---

ORA-26084: direct path context already finished

1937

---

NZE-28868: Peer certificate chain check failed.

2787

---

NZE-28890: Entrust Login Failed

1863

---

ORA-26032: index string.string loading aborted after string keys

2089

---

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

1926

---

ORA-16516: The current state is invalid for the attempted operation.

8802

---

IMP-00064: Definition of LOB was truncated by export

6396

---

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

---

IMP-00070: Lob definitions in dump file are inconsistent with database.

1732

---