You say "I do not have much idea about materialized views.".
Which leads me to suggest that you first get a good understanding of materialized views.
I'm not trying to ridicule you, it's just that there is a whole lot of things that can cause a MV to behave different then you would think.
In this case I wouldn't be surprised if what you're trying to do is a "fast refresh" (=wrong term, read Tom Kyte: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:10128040625700).
And if so, again I wouldn't be surprised if you did not create a Materialized View Log on each and every underlying table of each and every view that is used for this MV.
Rob van Wijk, a dutch guy I had the pleasure to work with, has posted a couple of extensive articles about the problems he encountered with fast refresh.
They might be of help to you. They were to me.
=> http://rwijk.blogspot.com/2009/05/fast-refreshable-materialized-view.html
=> http://rwijk.blogspot.com/2009/05/fast-refreshable-materialized-view_31.html
=> http://rwijk.blogspot.com/search?q=materialized+view&updated-max=2009-06-26T01%3A08%3A00%2B02%3A00&max-results=20
Which leads me to suggest that you first get a good understanding of materialized views.
I'm not trying to ridicule you, it's just that there is a whole lot of things that can cause a MV to behave different then you would think.
In this case I wouldn't be surprised if what you're trying to do is a "fast refresh" (=wrong term, read Tom Kyte: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:10128040625700).
And if so, again I wouldn't be surprised if you did not create a Materialized View Log on each and every underlying table of each and every view that is used for this MV.
Rob van Wijk, a dutch guy I had the pleasure to work with, has posted a couple of extensive articles about the problems he encountered with fast refresh.
They might be of help to you. They were to me.
=> http://rwijk.blogspot.com/2009/05/fast-refreshable-materialized-view.html
=> http://rwijk.blogspot.com/2009/05/fast-refreshable-materialized-view_31.html
=> http://rwijk.blogspot.com/search?q=materialized+view&updated-max=2009-06-26T01%3A08%3A00%2B02%3A00&max-results=20
No comments:
Post a Comment