Friday, October 14, 2016

12c: Updates to Fast-Refresh Materialized Views with joins are lost after DB upgrade

An interesting article on My Oracle Support, "Updates Lost to Fast-Refresh Materialized Views with Joins After Upgrade to 12c" from document ID 2186836.1, tells us that an upgrade from 12.1.0.1 to 12.1.0.2 can negatively impact your fast-refresh materialized views with joins!  It seems that the system "covers up" the problem by having the last update date updated while the data does not get updated!!

2 comments:


  1. Thanks for the nice blog here.I was searching this one for a long time.This blog is very helpful for my studies..I got another one site also,which is same as yours Oracle OSB.Check this one also Oracle Fusion HCM Sure it will be helpful for you too..Once more iam thanking you for your creative blog.

    ReplyDelete