| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: streams vs. replication
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?
-----Original Message-----
From: Joe Smith [mailto:joe_dba_at_hotmail.com]
Sent: Thursday, July 21, 2005 11:44 AM
To: Mohan, Ross; oracle-l_at_freelists.org
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_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org]
>On Behalf Of Joe Smith
>Sent: Thursday, July 21, 2005 9:33 AM
>To: oracle-l_at_freelists.org
>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/
>
>--
>http://www.freelists.org/webpage/oracle-l
>--
>http://www.freelists.org/webpage/oracle-l
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 21 2005 - 11:03:41 CDT
 |
 |