This content has been marked as final. Show 2 replies
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?