| Materialized VIEW flush scenario [message #392183] |
Mon, 16 March 2009 20:16  |
rajesh_tns
Messages: 6
Registered: February 2009
|
Junior Member |
|
|
hi all
any solution for this scenario.
1)I have a master site and local site.
2)Materialized view is refreshed at local site... and the results are stored in a cache which Java uses .
3)Any request for the mview data is retrieved from cache.
4)Now I am refreshing matview again using fast refresh.. i.e only records that are changed in the master is updated at the local site.
5) I have to flush the cache .. while flushing i have to flush only those records that are changed.... coz full flush is not good and i have to recache the entire data if i do full flush
My Question is How to identify the records that changed....so that I can only flush those records from cache..
I want to identify the changed records........any ideas you get please.. share with me....
|
|
|
|
|
|
| Re: Materialized VIEW flush scenario [message #392341 is a reply to message #392304] |
Tue, 17 March 2009 09:47  |
rajesh_tns
Messages: 6
Registered: February 2009
|
Junior Member |
|
|
sorry i dont know the differences between the two types..
does the approach change if we are using one of them?
how about this ..
adding a column called Indicator_flag and mark them to 'C' if any record changed and allowed them to propogate to local replicas.
but if the answer is this simple if would have been implemented before itself..
am not sure about this answer.
please suggest
Regards
Raj
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
