Redo log is showing Delete & Insert instead of Update when we perform MView fast refresh
Dear Gurus,
I would like to raise a concern regarding our current setup with the fast refreshed on commit MView. We have noticed that the Create, Update, Delete transactions on the denormalized model captured by the MView are not reflected in the LogMiner in the same way as regular tables.
As this feature is crucial for our system, we kindly request your assistance in ensuring that each transaction on the fast refreshed on commit MView is reflected on one row (Create/Update/Delete) in the LogMiner, similar to regular tables.
Thank you for your attention to this matter. Please let us know if you require any further information from our end.