Commit Time – Part 2 (On Commit Trigger) Mustafa, 2019-12-192019-12-19 Hello again, Not long ago, I mentioned about how to get approximate commit time on a table: https://mustafakalayci.me/2019/05/25/commit-time-for-an-inserted-row-in-oracle/ While I was reading some blogs and jumping from one to another, I came to Saibabu Devabhaktuni’n blog post: http://sai-oracle.blogspot.com/2013/09/how-to-setup-oracle-on-commit-trigger.html and I was literally shocked because I never heard something about this…. Continue Reading
Can not Drop Materialized View on 12c and above? Mustafa, 2019-12-06 Hello Everyone, I couldn’t write for a long time because of a crazy workload. During this heavy hardworking, I faced with a problem on one of my customers. They have a on commit refresh Materialized View (MV) and started to complain about they couldn’t insert into main table of MV…. Continue Reading