| 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,
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".
-----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.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 21 2005 - 10:35:55 CDT
 |
 |