out of place refresh in 12c mview
sudheer godgeri, January 06, 2021 - 3:16 pm UTC
I think the issue was:
during out of place refresh -- the mview's internal object ID used to change i.e a new mview table was created, which was refreshed, the older table was dropped and mview switched to the new table --this had a bug n 12.1 -- i.e the new object id caused the existing grants to fail i.e we had to re-do the grants to roles/users who queried / used the mview object : This was fixed i believe in 12.2 and later where we did not have to re-do the grants.
January 06, 2021 - 5:03 pm UTC
Thanks for letting us know.