Repgen Features
and Benefits
Repgen
Demo Available for download...
-- script name: reppkcolumns
-- Features: Creates the primary key column for all replicated tables
-- and makes it the primary key for the table. The commands in this
file
-- are designed to be used to fix up tables not containing a primary
key
-- which were not originally designed to be replicated.
-- This file must only be used for the master site prod5.
-- 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
-- ########## customers
ALTER TABLE WIDGETS1.CUSTOMERS ADD ID NUMBER NOT NULL;
COMMENT ON COLUMN WIDGETS1.CUSTOMERS.ID IS 'Provides primary key for
replication.';
ALTER TABLE WIDGETS1.CUSTOMERS ADD CONSTRAINT CUSTOMERS_PK
PRIMARY KEY (ID)
USING INDEX PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE indx
STORAGE(MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0);
-- ########## addresses
ALTER TABLE WIDGETS1.ADDRESSES ADD ID NUMBER NOT NULL;
COMMENT ON COLUMN WIDGETS1.ADDRESSES.ID IS 'Provides primary key for
replication.';
ALTER TABLE WIDGETS1.ADDRESSES ADD CONSTRAINT ADDRESSES_PK
PRIMARY KEY (ID)
USING INDEX PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE indx
STORAGE(MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0);
-- ************** static_tables_repgroup
-- ########## state_province
ALTER TABLE WIDGETS1.STATE_PROVINCE ADD ID NUMBER NOT NULL;
COMMENT ON COLUMN WIDGETS1.STATE_PROVINCE.ID IS 'Provides primary key
for replication.';
ALTER TABLE WIDGETS1.STATE_PROVINCE ADD CONSTRAINT STATE_PROVINCE_PK
PRIMARY KEY (ID)
USING INDEX PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE indx
STORAGE(MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0);
-- ########## country
ALTER TABLE WIDGETS1.COUNTRY ADD ID NUMBER NOT NULL;
COMMENT ON COLUMN WIDGETS1.COUNTRY.ID IS 'Provides primary key for replication.';
ALTER TABLE WIDGETS1.COUNTRY ADD CONSTRAINT COUNTRY_PK
PRIMARY KEY (ID)
USING INDEX PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE indx
STORAGE(MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0);
