Database DataWarehousing (MOSC)

MOSC Banner

Mview refresh issue

edited Jan 13, 2014 8:31PM in Database DataWarehousing (MOSC) 5 commentsAnswered
Hi All,

 when refreshing this mview im getting this error,i have tried this with mview owner,sys,system but i can't get this refreshed..anyone can help me out? version is 11203 in linux

exec dbms_mview.refresh'mview_fin.MV_PS_VENDOR_WTHD','F');

ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 364
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 446
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: at "SYS.DBMS_IREFRESH", line 685
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1

Thanks!

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