Oracle 高级复制多主体

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;
/