Home » Server Options » Replication » 3 Master sites - Group Problem ?!
3 Master sites - Group Problem ?! [message #75558] Wed, 20 October 2004 02:57
Deon
Messages: 6
Registered: September 2004
Junior Member
Hi Guys
 
I have 3 master sites called
 
CENTDB
DESTDB
TRANSDB
 
Each master site have 3 UMW (updatable materialized view) sites linked to it.
 
e.g
 
DESTDB  --> SITE X
               --> SITE Y
               --> SITE Z
 
The database links was created in the following order so that the changes
made in CENTDB will be reflected in DESTDB and the changes in DESTDB
will reflect in TRANSDB
 
CENTDB --> DESTDB
DESTDB --> TRANSDB
 
I created the 2 groups for the master sites as follows
 
Group 1  = "sysadm_mg" between CENTDB --> DESTDB
 

<DIV>Group 2  = "sysadm_mg1" between DESTDB --> TRANSDB</DIV>
 
This is now where my problem comes in ..
 
I created the replication support for the tables ("emp", "emp_details")  I added  in the 'sysadm_mg" group,
but when I create the replication support for the same tables ("emp", "emp_details") on the "sysadm_mg1" group it removes
the replication support for the tables ("emp", "emp_details")  form the "sysadm_mg" group and only have them in the
"sysadm_mg1" group
 
Any help will be appreciated
Previous Topic: delete bulk rows from table
Next Topic: MATERIALIZED VIEW
Goto Forum:
  


Current Time: Sat Apr 04 05:23:55 CDT 2020