Database DataWarehousing (MOSC)

MOSC Banner

System - Create Materialized View

edited Apr 25, 2012 9:37PM in Database DataWarehousing (MOSC) 5 commentsAnswered
I'm logged in with system and issue Create Materialized View user.mview_test build immediate refresh fast on demand as select ...

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center