oracle数据库实现不同数据库之间的表格数据定期同步

1、创建数据库连接

CREATE PUBLIC DATABASE LINK DBLINK01 CONNECT TO 用户名 IDENTIFIED BY 密码 USING '(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
    )
  )';

2、创建存储过程

create or replace procedure test as   
begin   
DELETE FROM table_name;
INSERT INTO table_name
select * from table_nameend;

3、创建定时任务

declare  
job1 number;   
begin  
dbms_job.submit(job1,  
     what => 'test;',  
     next_date => sysdate,  
     interval => 'TRUNC(sysdate) + 1 + 1 / (24)');
   commit;  
end;

// 查询当前数据库的所有定时任务
select * from All_JOBS;  

// 运行某个定时任务
begin
dbms_job.run(job_id);
commit;
end;

 

转载于:https://www.cnblogs.com/DreamSeekerming/p/9160872.html