Hi all,
I just refreshed my Mview. checked the status but it came up as UNUSABLE. Apart from re-running the refresh, what could be the issue?.
Two other mviews were refreshed off the same base table and there OK.
Thanks