Materialized View : Compile v/s refresh.
556597Sep 18 2008 — edited Sep 18 2008Hi All,
I need to understand what actually happens in the backend when we issue the command
"alter materialized view <MV name> compile;". Not only for MVs but also for all the other objects. What actually we mean when we say that an object is invalid and what does compile statement do to make it valid again ?
Also I would like to know how refreshing a MV is different from compiling a MV. I know when we refresh a MV the data fetched by the query is poured into the MV but I have observed that even after that the MV is invalid.
Any help would be appreciated.
Thanks,
Vihang.
Edited by: user553594 on Sep 18, 2008 12:45 AM
Edited by: user553594 on Sep 18, 2008 12:46 AM