This content has been marked as final. Show 1 reply
Yes you can use MV. The big advantage of a Materialized View is fast retrieval of aggregate data, since it is precomputed and stored, at the expense of insert/update/delete.
Here is the main difference
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