Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Please enter a title.
You can not post a blank message. Please type your message and try again.
Performance & Availability
This discussion is archived
on Jan 24, 2013 5:52 PM by user12107329
LCR for updates on FAST REFRESH MATERIALIZED VIEWS.
Jan 24, 2013 1:06 PM
I am using streams to capture changes from a ON COMMIT FAST REFRESH MATERIALIZED VIEW (with several source tables).
Both Capture and APLY process are working fine. No problems with it.
If we perform a simple update in one of the source tables, in the end, we are receiving two LCRs: one with delete command and another with insert command.
My first question why there is two LCR operations (delete and insert) instead of one (update). Is it due to the MV implementation?
Is there any mechanism or configuration where we are able to receive an update command instead of "delete and insert"? What are the trade offs?
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: LCR for updates on FAST REFRESH MATERIALIZED VIEWS.
Jan 24, 2013 5:52 PM
in response to
This post answers my question:
Many Thanks Alberto