STALENESS STALE and not FRESH in USER_MVIEWS after refresh
I have a simple table in schema A with a mat.view log and a fast refreshable mat.view in schema B referencing table from A. It is only a simple "select * from a.table" mat. view.
After I have done a fast refresh the value of STALENESS in USER_MVIEWS is STALE, after a complete refresh it's NEEDS_COMPILE. Why isn't it FRESH?
How can I trust the USER_MVIEWS dictionary view?