Oracle-L: RE: Replication

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 14 Apr 2003 06:49:18 -0800
Message-ID: <F001.0058061C.20030414064918@fatcity.com>

Arvind

I haven't used replication, only studied it. But I will mention the only two books I could find on the topic, and with the scale of your system, I would highly recommend them:
Oracle Distributed Systems by Charles Dye Data Replication by Marie Buretta

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, April 14, 2003 6:09 AM
To: Multiple recipients of list ORACLE-L

Hi,

i have to set replication environment for 5 sites.out of 5 sites one site is of head office (head1) and remaining 4 (branch1,branch2,branch3 and branch4) are for branch office.at each site oracle DB has been installed with Replication support.there are four tables t1,t2,t3 and t4 at each branch's server including the head1.at every branch data entry is being done into these 4 tables, except the head office.now i want each branch office server should update the tables at the head office server say

       branch1's table  t1 should update t1 table at head1 
       branch1's table t2 should update t2 table at head1...
 
       branch2's table  t1 should update the same  t1 table at head1 
       branch1's table  t2 should update the same  t2 table at head1 .....
   

       this is for all branch offices 

       but

       branch1's  table 1 should not update any of the another branches

tables.....

means all the branch office database should update only the head office tables not any other branch tables...

pls suggest how should i setup replication....

Regards
Arvind
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Arvind Kumar
INET: arvindk_at_sqlstarintl.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------