Joe, I'd be extending beyond what I experientially know if I tried to answer accurately. I'm sure you don't need me to tell you what I'd be doing: checking the 9206 bug fix list under the "streams" subheading, to determine what was fixed. But, yea: something about going to "6" rang a bell. Best of luck to you, keep us posted, willya? - Ross -----Original Message----- From: Joe Smith [mailto:joe_dba@xxxxxxxxxxx] Sent: Thursday, July 21, 2005 11:44 AM To: Mohan, Ross; oracle-l@xxxxxxxxxxxxx Subject: RE: streams vs. replication That is another question. Do you really have to be at 9.2.0.6.0? If not, are you asking for trouble? thanks. >Joe, > >from what little I know, you want at least 92060 to get Streams >stability, and 10g to get the full feature set. > ><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 > > >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/ > >-- >//www.freelists.org/webpage/oracle-l >-- >//www.freelists.org/webpage/oracle-l _________________________________________________________________ FREE pop-up blocking with the new MSN Toolbar - get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ -- //www.freelists.org/webpage/oracle-l