error refreshing MV ....
Hello all,
I am trying to refresh a MV using the below cmd..i get thsi error? I treid it with sys, with the user itself..same thing...also treid...begin and end cluase...same error....the MV was create with this cluasse " REFRESH COMPLETE ON DEMAND " ....would that play a role in this refresh ??
SQL> EXECUTE DBMS_MVIEW.REFRESH(User.TEST_MV);
BEGIN DBMS_MVIEW.REFRESH(User.TEST_MV); END;
*
ERROR at line 1:
ORA-06550: line 1, column 35:
PLS-00357: Table,View Or Sequence reference 'User.TEST_MV' not allowed in
this context
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored