Repgen Features
and Benefits
Repgen
Demo Available for download...
-- script name: repremovegroup
-- Features: Removes each replication group and its conflict resolution
-- methods and conflict resolution column grouping from 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
-- drop conflict resolution methods
execute dbms_repcat.drop_update_resolution(sname =>'widgets1', oname
=>'customers', column_group => 'date_modified_cr_date', sequence_no
=>1);
execute dbms_repcat.drop_update_resolution(sname =>'widgets1', oname
=>'customers', column_group => 'date_modified_cr_date', sequence_no
=>2);
execute dbms_repcat.drop_update_resolution(sname =>'widgets1', oname
=>'addresses', column_group => 'date_updated_cr_date', sequence_no =>1);
execute dbms_repcat.drop_update_resolution(sname =>'widgets1', oname
=>'addresses', column_group => 'date_updated_cr_date', sequence_no =>2);
-- drop column groups
execute dbms_repcat.drop_column_group(sname =>'widgets1', oname =>'customers',
column_group => 'date_modified_cr_date');
execute dbms_repcat.drop_column_group(sname =>'widgets1', oname =>'addresses',
column_group => 'date_updated_cr_date');
-- drop the tables from the repgroup
execute dbms_repcat.drop_master_repobject(sname =>'widgets1', oname
=>'customers', type => 'table', drop_objects => FALSE);
execute dbms_repcat.drop_master_repobject(sname =>'widgets1', oname
=>'addresses', type => 'table', drop_objects => FALSE);
-- drop the group
execute dbms_repcat.drop_master_repgroup (gname =>'customer_repgroup',
drop_contents =>FALSE, all_sites => TRUE);
-- push admin requests to all sites
execute dbms_repcat.do_deferred_repcat_admin(gname =>'customer_repgroup',
all_sites => TRUE);
-- ************** static_tables_repgroup
-- drop conflict resolution methods
execute dbms_repcat.drop_update_resolution(sname =>'widgets1', oname
=>'state_province', column_group => 'date_modified_cr_date', sequence_no
=>1);
execute dbms_repcat.drop_update_resolution(sname =>'widgets1', oname
=>'state_province', column_group => 'date_modified_cr_date', sequence_no
=>2);
execute dbms_repcat.drop_update_resolution(sname =>'widgets1', oname
=>'country', column_group => 'date_modified_cr_date', sequence_no =>1);
execute dbms_repcat.drop_update_resolution(sname =>'widgets1', oname
=>'country', column_group => 'date_modified_cr_date', sequence_no =>2);
-- drop column groups
execute dbms_repcat.drop_column_group(sname =>'widgets1', oname =>'state_province',
column_group => 'date_modified_cr_date');
execute dbms_repcat.drop_column_group(sname =>'widgets1', oname =>'country',
column_group => 'date_modified_cr_date');
-- drop the tables from the repgroup
execute dbms_repcat.drop_master_repobject(sname =>'widgets1', oname
=>'state_province', type => 'table', drop_objects => FALSE);
execute dbms_repcat.drop_master_repobject(sname =>'widgets1', oname
=>'country', type => 'table', drop_objects => FALSE);
-- drop the group
execute dbms_repcat.drop_master_repgroup (gname =>'static_tables_repgroup',
drop_contents =>FALSE, all_sites => TRUE);
-- push admin requests to all sites
execute dbms_repcat.do_deferred_repcat_admin(gname =>'static_tables_repgroup',
all_sites => TRUE);
