How To Implement A VPD Policy Working With Materialized Views to Avoid ORA-30372
Last updated on MARCH 29, 2017
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 9.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 21-Feb-2013***
This document describes a method to avoid encountering an ORA-30372 error when attempting to create a materialized view on a table which is also managed by fine grain access control.
You receive the following error when you commit an insert to a table:
1 row created.
ERROR at line 1:
ORA-12008: error in materialized view refresh path
ORA-30372: fine grain access policy conflicts with materialized view
You have both a restrictive VPD policy defined on the table and a materialized view with the attribute REFRESH FAST ON COMMIT, for example:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms