This content has been marked as final. Show 4 replies
Thanks for your quick response. I have gone through the documents. But here they covered MQ,STREAM .. concepts...
But I would like to know where and what exactly Oracle Streams and in what conditions we are going to use this concept. Can any one please explain me.
Which one is suggested?Both.
The documentation [url http://docs.oracle.com/cd/E11882_01/server.112/e17516/tdpii_intro2ii.htm#autoId6]is quite clear:
Use Streams when you want an exact copy of the data, with near real time replication and you have guaranteed continuous network capacity to deliver it.
Use Materialized Views when you want to replicate sub-sets or aggregations of your data, or you don't need NRT replicdation.
Edited by: APC on Apr 4, 2013 2:58 PM