Last Refresh property for MViews

[SunDog]

I have a Materialized View and if I right-click and select Properties, it shows me a LAST_REFRESH date. But when I query user_mviews, LAST_REFRESH_DATE is Null. So where is the property panel getting its date from?

 

[Marco Kalter]

The properties are taken from both the ALL_MVIEWS and ALL_SNAPSHOTS views. The LAST_REFRESH_DATE value comes from the ALL_MVIEWS view. The LAST_REFRESH value comes from the ALL_SNAPSHOTS view.