|
|
Re: Oracle streams or MVs or database triggers [message #509650 is a reply to message #509440] |
Mon, 30 May 2011 15:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/5c8057cd412d1aac891fa1ce7e0be5cb?s=64&d=mm&r=g) |
aritor
Messages: 2 Registered: May 2011 Location: Norway
|
Junior Member |
|
|
Thank you for your answer.
I tend towards the basic replication (read-only materialized views) method, which you mention.
After each manual refresh I could merge data to a new historic table on the materialized view site to keep data longer than the master tables.
I am new with this replication methods, so it's always good to get a second opinion from other Oracle people.
|
|
|