ORA-30372 fine grain access policy conflicts with materialized view ORA-30372 fine grain access policy conflicts with materialized view oracle oracle

ORA-30372 fine grain access policy conflicts with materialized view


I found a Solution By using

REFRESH FORCE ON DEMAND WITH ROWID USING TRUSTED CONSTRAINTS

In my case I have table with aprox. 100 record, it's a small table so I can use ROWID. But using ROWID on a Big table is not good idea, because it will search the row in whole table, and replication of table will take too long time.


All you need is:REFRESH FORCE ON DEMAND USING TRUSTED CONSTRAINTS.

That way your query can ignore restrictions imposed by Oracle VPD.