Database Administration (MOSC)

MOSC Banner

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')

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center