5 Replies Latest reply: May 28, 2010 11:44 AM by Chinar RSS

    ORA-01435: user does not exist while executing dbms_scheduler

    591186
      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