9 Replies Latest reply: Nov 30, 2012 4:08 PM by StewStryker RSS

    Error: ORA-30372: fine grain access policy conflicts with material

    693765
      Hi all,
      I have a table, named A, that a policy is defined on it.
      On table A I have a view, named A_view, that select several columns.
      So far, it works properly.

      I try to define a materilized view on the view A_view but I get the following error:
      Error: ORA-30372: fine grain access policy conflicts with material.

      I have read few posts regarding this error and I found a post that says to add to following to
      the policy function:
      IF dbms_mview.i_am_a_refresh THEN
      v_predicate:=NULL;
      else....

      But it doesn't work and I still get the error mentioned above.
      Does anybody know how to solve this error?
      Thanks
      dyahav