Checking Status of Oracle Materialized View

Checking status of an Oracle Materialized View
Few basic SQL to checking status of Oracle Materialized View.
Common Error ORA-12034: materialized view log on"DEV_USER"."NFS_MOUNT" younger than last refresh
Checks -- Change OWNER SQL> SELECT owner, object_name, object_type, status from dba_objects WHERE owner='DEV_USER' and object_type='MATERIALIZED VIEW'; OWNER OBJECT_NAME OBJECT_TYPE STATUS --------------- ----------------- ------------------- ------- DEV_USER NFS_MOUNT MATERIALIZED VIEW VALID SQL> SELECT owner, mview_name, last_refresh_date, staleness FROM dba_mviews WHERE owner ='DEV_USER'; OWNER MVIEW_NAME LAST_REFRESH_DATE STALENESS --------------- ----------------- -------------------- -------------- DEV_USER NFS_MOUNT 29-OCT-20 UNDEFINED