2 Replies Latest reply: Jun 26, 2013 7:29 AM by swapnil kambli RSS

    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?

       

      Thanks,
      Swapnil.