We have requirement to replicate few tables from one site to another site and site to site connected with highspeed network. Table is highly transactional and customer wants see commited data immediately into another centre. it is simple one to one replication and no conditions or joins. Will materialized view fast refresh commit is good solution in this scenario ? Any cons if we use MV instead of stream in my scenario? pls advise
Based upon what you have explained, i dont think you need streams.
You can refer below links
Hope this helps,
RMAN Debug and Trace
Time for Change: Migrate your Non-RAC Database to RAC