2 Replies Latest reply on Jun 26, 2013 12:29 PM by swapnil kambli

    scheduler job failure for data refresh over dblink

    swapnil kambli

      Hi ,


      I am trying to import (only new ) data through a db link.


      exec dbms_scheduler.create_job ( Job_name=> 'update_table1_job', Job_type=> 'PLSQL_BLOCK', Job_action=> 'declare begin insert into table1_TEMP_2 select * from table1@dblink1 where  pxtimeCreated > (select max(pxtimeCreated) from table1_temp_2);commit;end; /', Start_date=> '26-JUN-2013 04:53:00 AM America/Phoenix', Repeat_interval=> 'FREQ=MINUTELY;INTERVAL=5', Comments=> 'This job updates table1 based on new records from table2', enabled=> TRUE )


      Job gets created but failes with error 6550


      I am unable to create a view on this remote table as it contains LOB column.


      Could you please help?