Oracle version 10.2.0.4
SunOS 9
I have converted some of our materialized views refreshes from dbms_job to dbms_scheduler. When i execute the materialized view refresh manually, it works fine. Whereas,when scheduled through scheduler,its not running and giving the below error.
The same jobs are running fine with dbms_jobs.
begin dbms_scheduler.create_job(
job_name=>'MV_MRT_GP_JOB'',
job_type => 'PLSQL_BLOCK',
job_action=> 'begin
dbms_refresh.refresh(''"USER"."'MV_MRT_GP"'');
end; ',
start_date => to_timestamp('05/28/2010 10:00:00', 'mm/dd/yyyy hh24:mi:ss'),
repeat_interval => 'freq=daily; byhour=5; byminute=0; bysecond=0;',
enabled => true, auto_drop=> false,
comments => 'Converted from job 704'
);
end;
/
PL/SQL procedure successfully completed.
exec dbms_scheduler.run_job('MV_MRT_GP_JOB');
ERROR at line 1:
ORA-01435: user does not exist
ORA-06512: at "SYS.DBMS_ISCHED", line 150
ORA-06512: at "SYS.DBMS_SCHEDULER", line 441
ORA-06512: at line 1
I connected as the USER owns these materialized views.
what is that i am missing here?
-Anantha