System - Create Materialized View
I get
ORA-01031: insufficient privileges
If I run the select as system then I get results. I grant create materialized view to system but still same error.
Then I loggin as Application DB User. I issue Create Materialized View user.mview_test build immediate refresh fast on demand as select ...
and the Materialized View is created.
Why I can't create it with System? My main problem is that I import(impdp) using network_link and I get this error.