Mview refresh issue
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!
0