Repgen Features
and Benefits
Repgen
Demo Available for download...
-- script name: repaddtable
-- Features: Adds tables to each replication group along with the conflict
resolution
-- methods and conflict resolution column grouping to all master sites.
-- NOTE: This file must only be run at the master definition site prod3.
-- Copyright 2002 by .com Solutions Inc.
-- This output file was created by Repgen version 2.2.4 on Fri May 31
13:29:24 2002. By .com Solutions Inc. www.dotcomsolutionsinc.net
-- ************** customer_repgroup
select gname, master, status from dba_repgroup where gname = 'CUSTOMER_REPGROUP';
-- add each table to the repgroup
execute dbms_repcat.create_master_repobject(sname =>'widgets1', oname
=>'customers', type => 'table', gname=>'customer_repgroup', use_existing_object=>TRUE,
copy_rows=>FALSE);
execute dbms_repcat.create_master_repobject(sname =>'widgets1', oname
=>'addresses', type => 'table', gname=>'customer_repgroup', use_existing_object=>TRUE,
copy_rows=>FALSE);
-- push admin requests to all sites
execute dbms_repcat.do_deferred_repcat_admin(gname =>'customer_repgroup',
all_sites => TRUE);
-- add conflict resolution column group for each table
execute dbms_repcat.make_column_group(sname =>'widgets1', oname =>'customers',
column_group =>'customers_cr_date', list_of_column_names =>'*');
execute dbms_repcat.make_column_group(sname =>'widgets1', oname =>'addresses',
column_group =>'addresses_cr_date', list_of_column_names =>'*');
-- push admin requests to all sites
execute dbms_repcat.do_deferred_repcat_admin(gname =>'customer_repgroup',
all_sites => TRUE);
-- add conflict resolution methods
execute dbms_repcat.add_update_resolution(sname =>'widgets1', oname
=>'customers', column_group => 'customers_cr_date', sequence_no =>1,
method =>'LATEST TIMESTAMP', parameter_column_name =>'date_modified');
execute dbms_repcat.add_update_resolution(sname =>'widgets1', oname
=>'customers', column_group => 'customers_cr_date', sequence_no =>2,
method =>'SITE PRIORITY', parameter_column_name =>'site_name', priority_group
=>'site_sp');
execute dbms_repcat.add_update_resolution(sname =>'widgets1', oname
=>'customers', column_group => 'customers_cr_date', sequence_no =>3,
method =>'OVERWRITE', parameter_column_name =>'*');
execute dbms_repcat.add_update_resolution(sname =>'widgets1', oname
=>'addresses', column_group => 'addresses_cr_date', sequence_no =>1,
method =>'LATEST TIMESTAMP', parameter_column_name =>'date_updated');
execute dbms_repcat.add_update_resolution(sname =>'widgets1', oname
=>'addresses', column_group => 'addresses_cr_date', sequence_no =>2,
method =>'SITE PRIORITY', parameter_column_name =>'site_id', priority_group
=>'site_sp');
execute dbms_repcat.add_update_resolution(sname =>'widgets1', oname
=>'addresses', column_group => 'addresses_cr_date', sequence_no =>3,
method =>'OVERWRITE', parameter_column_name =>'*');
-- push admin requests to all sites
execute dbms_repcat.do_deferred_repcat_admin(gname =>'customer_repgroup',
all_sites => TRUE);
-- ************** static_tables_repgroup
select gname, master, status from dba_repgroup where gname = 'STATIC_TABLES_REPGROUP';
-- add each table to the repgroup
execute dbms_repcat.create_master_repobject(sname =>'widgets1', oname
=>'state_province', type => 'table', gname=>'static_tables_repgroup',
use_existing_object=>TRUE, copy_rows=>FALSE);
execute dbms_repcat.create_master_repobject(sname =>'widgets1', oname
=>'country', type => 'table', gname=>'static_tables_repgroup', use_existing_object=>TRUE,
copy_rows=>FALSE);
-- push admin requests to all sites
execute dbms_repcat.do_deferred_repcat_admin(gname =>'static_tables_repgroup',
all_sites => TRUE);
-- add conflict resolution column group for each table
execute dbms_repcat.make_column_group(sname =>'widgets1', oname =>'state_province',
column_group =>'state_province_cr_date', list_of_column_names =>'*');
execute dbms_repcat.make_column_group(sname =>'widgets1', oname =>'country',
column_group =>'country_cr_date', list_of_column_names =>'*');
-- push admin requests to all sites
execute dbms_repcat.do_deferred_repcat_admin(gname =>'static_tables_repgroup',
all_sites => TRUE);
-- add conflict resolution methods
execute dbms_repcat.add_update_resolution(sname =>'widgets1', oname
=>'state_province', column_group => 'state_province_cr_date', sequence_no
=>1, method =>'LATEST TIMESTAMP', parameter_column_name =>'date_modified');
execute dbms_repcat.add_update_resolution(sname =>'widgets1', oname
=>'state_province', column_group => 'state_province_cr_date', sequence_no
=>2, method =>'SITE PRIORITY', parameter_column_name =>'site_name',
priority_group =>'site_sp');
execute dbms_repcat.add_update_resolution(sname =>'widgets1', oname
=>'state_province', column_group => 'state_province_cr_date', sequence_no
=>3, method =>'OVERWRITE', parameter_column_name =>'*');
execute dbms_repcat.add_update_resolution(sname =>'widgets1', oname
=>'country', column_group => 'country_cr_date', sequence_no =>1, method
=>'LATEST TIMESTAMP', parameter_column_name =>'date_modified');
execute dbms_repcat.add_update_resolution(sname =>'widgets1', oname
=>'country', column_group => 'country_cr_date', sequence_no =>2, method
=>'SITE PRIORITY', parameter_column_name =>'site_id', priority_group
=>'site_sp');
execute dbms_repcat.add_update_resolution(sname =>'widgets1', oname
=>'country', column_group => 'country_cr_date', sequence_no =>3, method
=>'OVERWRITE', parameter_column_name =>'*');
-- push admin requests to all sites
execute dbms_repcat.do_deferred_repcat_admin(gname =>'static_tables_repgroup',
all_sites => TRUE);
