One way to handle this problem is to not schedule your jobs to push
from Y and Z to X. If transactions occur on Y and Z, they will become
deferred transactions, waiting to be pushed to X, but will never push.
Then, periodically you can delete the transactions from Y and Z (bound for
X). I suppose you could setup a cron to do the purge automatically...
Hope that helps,
Alan
"Softhome -
Fico" To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
<ficomail@soft cc:
home.net> Subject: One way replication in
multimaster environment
Sent by:
[EMAIL PROTECTED]
om
05/02/02 10:18
PM
Please respond
to ORACLE-L
hi experts,
In my replicated environment, i have one site (example: site X) that
consolidate data from other sites (example : site Y and Z).
I'm using multimaster to push transaction from site Y and Z to site X.
How can i set - off the replication in site X , cause i dont want site X to
push the changes to other sites or to disable row-level replication.
any idea ?
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Softhome - Fico
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).