Oracle-L: Re: One way replication in multimaster environment

From: <alan.aschenbrenner_at_ihs.com>
Date: Fri, 03 May 2002 10:24:16 -0800
Message-ID: <F001.00457949.20020503102416@fatcity.com>

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 <ORACLE-L_at_fatcity.com>       
                    <ficomail_at_soft       cc:                                                                       
                    home.net>            Subject:     One way replication in multimaster environment               
                    Sent by:                                                                                       
                    root_at_fatcity.c                                                                                 
                    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: ficomail_at_softhome.net

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: ListGuru_at_fatcity.com (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: alan.aschenbrenner_at_ihs.com

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: ListGuru_at_fatcity.com (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).

Received on Fri May 03 2002 - 13:24:16 CDT