PLS-00357 error
I have created MView under report_owner schema and like to refresh the MView via scheduler job and the MView won't get refreshed.i am getting this errors.
ORA-12012: error on auto execute of job 135426
ORA-06550: line 1, column 402:
PLS-00357: Table,View Or Sequence reference 'REPORT_OWNER.M_REP_01'
SQL> l
1 BEGIN
2 sys.dbms_scheduler.create_job(
3 job_name => '"SYSTEM"."REFRESH_MVIEWS"',
4 job_type => 'PLSQL_BLOCK',
5 job_action => 'BEGIN
dbms_mview.refresh(list=>"REPORT_OWNER"."M_REP_01");END;',
6 job_class => 'AUTO_TASKS_JOB_CLASS',
7 start_date => SYSTIMESTAMP,
8 repeat_interval => 'FREQ=MINUTELY',
9 end_date => NULL,
10 enabled => TRUE,
11 comments => 'To refresh REPORT_OWNER schema MViews');
12* END;
SQL> /
PL/SQL procedure successfully completed.
So what is the problem ??