Oracle-L: Replication

From: Arvind Kumar <arvindk_at_sqlstarintl.com>
Date: Mon, 14 Apr 2003 03:08:36 -0800
Message-ID: <F001.00580430.20030414030836@fatcity.com>

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). Received on Mon Apr 14 2003 - 06:08:36 CDT