RE: streams vs. replication

  • From: "Mohan, Ross" <RMohan@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 21 Jul 2005 15:33:38 -0000


from what little I know, you want at least 92060 to get
Streams stability, and 10g to get the full feature

<market speak> They are moving from trigger-based replication.
The statement is "if you haven't committed to replication or
streams yet, pick Streams".

- Ross

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Joe Smith
Sent: Thursday, July 21, 2005 9:33 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: streams vs. replication


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 

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 

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.


Don't just search. Find. Check out the new MSN Search!


Other related posts: