Oracle 高级复制多主体
BEGIN
DBMS_REPCAT.CREATE_MASTER_REPGROUP(
gname => '"REP_GROUP1"',
qualifier => '',
group_comment => '');
END;
/
BEGIN
DBMS_REPCAT.CREATE_MASTER_REPOBJECT(
gname => '"REP_GROUP1"',
type => 'TABLE',
oname => '"BONUS"',
sname => '"SCOTT"',
copy_rows => TRUE,
use_existing_object =>
TRUE);
END;
/
BEGIN
DBMS_REPCAT.SET_COLUMNS(
sname => '"SCOTT"',
oname => '"BONUS"',
column_list
=> '"ENAME"');
END;
/
BEGIN
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT(
sname => '"SCOTT"',
oname => '"BONUS"',
type => 'TABLE',
min_communication => TRUE,
generate_80_compatible => FALSE);
END;
/
BEGIN
DBMS_REPCAT.RESUME_MASTER_ACTIVITY(
gname => '"REP_GROUP1"');
END;
/
BEGIN
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT(
sname => '"SCOTT"',
oname => '"BONUS"',
type => 'TABLE',
min_communication => TRUE,
generate_80_compatible => FALSE);
END;
/
BEGIN DBMS_DEFER_SYS.SCHEDULE_PUSH(destination =>
'DB12.US.ORACLE.COM', next_date => to_date('21-06-2007
11:24:31','DD-MM-YYYY HH24:MI:SS'), interval => 'sysdate + 1',
stop_on_error => FALSE, delay_seconds => 0, parallelism =>
0); END;
/
BEGIN DBMS_DEFER_SYS.SCHEDULE_PUSH(destination =>
'DB12.US.ORACLE.COM', next_date => to_date('21-06-2007
11:32:56','DD-MM-YYYY HH24:MI:SS'), interval => 'sysdate + 1',
stop_on_error => FALSE, delay_seconds => 0, parallelism =>
0); END;
/
