Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> streams vs. replication

streams vs. replication

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Thu, 21 Jul 2005 08:32:40 -0500
Message-ID: <BAY107-F203279A33F44B53E36827197D60@phx.gbl>


List,

I need advice on how to approach a task. I need to "replicate" 6 tables across 6 Sun Servers with of course their own oracle instance. This is 9iRel2, 9.2.0.5.0.

Any change made to any of the tables needs to be replicated to all the other tables. This is just DML changes. These tables are small.

Should I use traditional Oracle Replication or tackle it with Oracle Streams?

I realize from reading the manuals that replication is included within Streams, but I just want to make sure that my approach is right.

Any advice is appreciated.

thanks.



Donít just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 21 2005 - 08:34:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US