ALL_MVIEW_REFRESH_TIMES

ALL_MVIEW_REFRESH_TIMES describes refresh times of the materialized views accessible to the current user.

Related Views

  • DBA_MVIEW_REFRESH_TIMES describes refresh times of all materialized views in the database.

  • USER_MVIEW_REFRESH_TIMES describes refresh times of the materialized views owned by the current user.


Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the materialized view

NAME

VARCHAR2(128)

NOT NULL

Name of the materialized view

MASTER_OWNER

VARCHAR2(128)

 

Owner of the master table

MASTER

VARCHAR2(128)

 

Name of the For doc bug 14120613, added description LAST_REFRESH_END_TIME column in ALL_MVIEWS. The column description was provided in "Re: What description should I use for the new LAST_REFRESH_END_TIME column in [ALL|DBA]_MVIEWS?" August 30, 2013 11:31 AM email from tsae-feng.yu.master table

LAST_REFRESH

DATE

 

SYSDATE from the master site at the time of the last refresh