Database Administration (MOSC)

MOSC Banner

refresh materialized view ORA-01031: insufficient privilege

edited Apr 10, 2020 5:05AM in Database Administration (MOSC) 1 commentAnswered

Hi , Can anybody help me which privilegies i need : I have two schemas TEST1 , TEST2

in TEST1 i have materialialized view and I have privilege

Grant select on MW to TEST2

But from test 2 :

BEGIN dbms_snapshot.refresh('TEST1.MW', 'C',NESTED => true); END;

ERROR at line 1:

ORA-01031: insufficient privileges

BEGIN dbms_snapshot.refresh('TEST1.MW', 'C',NESTED => false); END;

ERROR at line 1:

ORA-23401: materialized view "O_DL_STARBYTE"."PKS" does not exist

Do you have idea how to solve it ?

Database version is 12.1.0.2  ... I didn't find solution or bug in metalink

thank You B.

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