详解Oracle分布式系统数据复制技术(1)(2)

CONNECT repadmin/repadmin@cl.world 
BEGIN 
DBMS_DEFER_SYS.SCHEDULE_PURGE ( 
next_date => SYSDATE, 
interval => ’SYSDATE + 1/24’, 
delay_seconds => 0); 
END;

CONNECT SYSTEM/MANAGER@cl.world 
CREATE PUBLIC DATABASE LINK js.world USING ’js.world’; 
CONNECT repadmin/repadmin@cl.world 
CREATE DATABASE LINK js.world CONNECT TO repadmin 
IDENTIFIED BY repadmin;

CONNECT SYSTEM/MANAGER@js.world 
CREATE PUBLIC DATABASE LINK cl.world USING ’cl.world’; 
CONNECT repadmin/repadmin@js.world 
CREATE DATABASE LINK cl.world CONNECT TO repadmin 
IDENTIFIED BY repadmin;

CONNECT repadmin/repadmin@cl.world 
BEGIN 
DBMS_DEFER_SYS.SCHEDULE_PUSH ( 
destination => ’js.world’, 
interval => ’SYSDATE + (1/144)’, 
next_date => SYSDATE, 
parallelism => 1, 
execution_seconds => 1500, 
delay_seconds => 1200); 
END;

CONNECT repadmin/repadmin@cl.world 
BEGIN 
DBMS_REPCAT.CREATE_MASTER_REPGROUP ( 
gname => ’inte_repg’); 
END;

BEGIN 
DBMS_REPCAT.CREATE_MASTER_REPOBJECT ( 
gname => ’inte_repg’, 
type => ’TABLE’, 
oname => ’survey’, 
sname => ’integration’, 
use_existing_object => TRUE, 
copy_rows => FALSE); 
END; 

BEGIN 
DBMS_REPCAT.ADD_MASTER_DATABASE ( 
gname => ’inte_repg’, 
master => ’js.world’, 
use_existing_objects => TRUE, 
copy_rows => FALSE, 
propagation_mode => ’ASYNCHRONOUS’); 
END;