Hello, I was getting the following error when creating and refreshing a materialized view:
ORA-30372 - "fine grain access policy conflicts with materialized view"
*Cause: A fine grain access control procedure has applied a non-null policy
to the query for the materialized view.
This error occurs, when you are creating/refreshing a materialized view on the base of a remote table which is located on another database where Virtual Private Database (VPD) is enabled.
The simplest workaround is to use the "USING TRUSTED CONSTRAINTS" keyword in the syntax:
I wish more authors of this type of content would take the time you did to research and write so well. I am very impressed with your vision and insight. Gratis Sportwetten
ReplyDelete