MV refresh - logging
Hi,
I'm doing a Refresh of a Materialized View, with success it seems, but then the DBA_MVIEWS views says no refresh was done (in the LAST_REFRESH_DATE column).
If the refresh was with success, that date should be updated, no ?
If there was an error with the refresh - which I think is the case - it should be reported by the feedback of the command, right ?
SQL> select OWNER,MVIEW_NAME,to_char(LAST_REFRESH_DATE,'dd/mm/yy hh24:mi') ,to_char(LAST_REFRESH_END_TIME,'dd/mm/yy hh24:mi') ,to_char(STALE_SINCE,'dd/mm/yy hh24:mi')