MV strategy
Andrew, September 21, 2016 - 7:37 am UTC
Thank you for your response.
I had sent this - as we had been facing the issue of MV refresh group NOT doing the job (Force on demand by cron shell script) - but rather executing it on the second try or later even. No idea as to why - as I do not have access privs to the database server, so unable to diagnose.
I am opting for using flashback technology instead of MV now but wanted to understand any/all possible root causes. Some had been listed by Oracle in Replication trouble shooting - again it is difficult to handle without any access to the DB server.
Thanks
Andrew