Oracle database enables regular synchronization of tabular data between different databases

1. Create a database connection

CREATE  Public DATABASE  to  by ' ( DESCRIPTION = (    ADDRESS = (PROTOCOL = TCP) (HOST = 134.103.65.206) (PORT = 1521))    (Connect_data =      (SERVICE _name = ORCL)  )';

2. Create a stored procedure

Create or Replace procedureTest as   begin   DELETE  fromKdfaultorder;INSERT  intoKdfaultorderSelectbusinessdataid id,title reporttitle,mainsn faultnumber, (SelectSpecialtyname fromCcatsupt. Pub_specialty@kdogg whereSpecialtyid=bigspecialty) Bigtype, (SelectSpecialtyname fromCcatsupt. Pub_specialty@kdogg whereSpecialtyid=Specialty) Smalltype, (SelectBusinessName fromCcatsupt.sys_business@kdogg whereBusinessid=Business ) Reporttype,sourcedept reportresource,firstrecepttime reporttime,reqrepairtime ENDTIME, (SelectObjectName fromCcatsupt.org_tree@kdogg whereItemid=repairoper) Dealperson,hastennum Repairnum,decode (Processflag,'declarate','Ticketing','Billdeal','in Work Order Processing','Hangup','Hang Up','VISIT','To return') Orderstatus,alarmstatus Warnstatus, (SelectObjectName fromCcatsupt.org_tree@kdogg whereItemid=RegionID) AreaName fromCcatsupt. Svr_pub_da_mainqueue@kdoggwhereArchiveType is NULL andFirstrecepttime<Sysdate- the/1140 andReqrepairtime>Sysdate- the/1140;End;

3. Create a timed task

DECLARE  number;    begin   dbms_job.submit (job1,       ='test; ' ,        = sysdate,        = ' TRUNC (sysdate) + 1 + 1/(PER) ' );    Commit ;   End;

//querying all scheduled tasks for the current databaseDeclareJob1 Number; beginDbms_job.submit (JOB1, what= 'test;', Next_date=sysdate, Interval= 'TRUNC (sysdate) + 1 + 1/(PER)'); Commit; End; //run a scheduled taskbeginDbms_job.run ( in);Commit;End;

Oracle database enables regular synchronization of tabular data between different databases