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
|
|
|