This content has been marked as final. Show 4 replies
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