Repgen Features
and Benefits
Repgen
Demo Available for download...
-- script name: repregen
-- Features: Regenerates replication support for all tables.
-- NOTE: When running repregen, do not run the entire file at once.
Select 5 tables
-- at a time from a single group, run the commands, then keep doing
this until
-- all of the tables for the group have been completed. Then check Replication
Manager
-- for status, and manually apply administrative requests until the
queue is empty.
-- 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';
execute dbms_repcat.generate_replication_support(sname =>'widgets1',
oname =>'customers', type =>'table');
execute dbms_repcat.generate_replication_support(sname =>'widgets1',
oname =>'addresses', type =>'table');
-- ************** static_tables_repgroup
select gname, master, status from dba_repgroup where gname = 'STATIC_TABLES_REPGROUP';
execute dbms_repcat.generate_replication_support(sname =>'widgets1',
oname =>'state_province', type =>'table');
execute dbms_repcat.generate_replication_support(sname =>'widgets1',
oname =>'country', type =>'table');
