Hello guys,
I have created a materialized view. When doing a FORCE refresh ON DEMAND on this view, the query :
SELECT * from XX_INV_MV
retruns no rows.
Therefore users must access to some datas when they query the MV, the old ones for example (datas from just before the refresh).
So is there any way that the we can access to old MV records during the refresh?
Thanks.