Home » Server Options » Streams & AQ » Who can tell me what the difference between relplication and streams?
Who can tell me what the difference between relplication and streams? [message #221189] Sat, 24 February 2007 23:26 Go to next message
xyz_hh
Messages: 11
Registered: February 2007
Junior Member
Which is better? Or what are they good at?
Thanks!
Re: Who can tell me what the difference between relplication and streams? [message #221698 is a reply to message #221189] Wed, 28 February 2007 02:00 Go to previous messageGo to next message
xyz_hh
Messages: 11
Registered: February 2007
Junior Member
nobody....
Re: Who can tell me what the difference between relplication and streams? [message #225880 is a reply to message #221698] Wed, 21 March 2007 16:18 Go to previous messageGo to next message
DmitriyS
Messages: 1
Registered: March 2007
Junior Member
I might be wrong, but Oracle Streams provide one of approaches that could be used for data replication.
Re: Who can tell me what the difference between relplication and streams? [message #225999 is a reply to message #221189] Thu, 22 March 2007 04:15 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Replication
Quote:
Replication is the process of copying and maintaining database objects, such as tables,in multiple databases that make up a distributed database system. Changes applied at one site
are captured and stored locally before being forwarded and applied at each of the remote locations.



Streams
Quote:
In a nutshell, streams allow information to flow from one database to another without the information having to be an exact copy of the originator.



[Updated on: Thu, 22 March 2007 04:16]

Report message to a moderator

Re: Who can tell me what the difference between relplication and streams? [message #230411 is a reply to message #225999] Wed, 11 April 2007 20:05 Go to previous message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Just to add up something.......Streams is not replicating data from one database to other database but it also replicating data from with in the database and outside the database, additionally it can replicate data on bidirectional and depending on rules set you can replicate only for certain DML like only for updates, only for inserts ..etc.

Cheers,
Harsh
Previous Topic: help me with AQ
Next Topic: Help Required to Implement Oracle AQ
Goto Forum:
  


Current Time: Thu Mar 28 04:35:16 CDT 2024