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(30)	NOT NULL	Owner of the materialized view
  NAME	VARCHAR2(30)	NOT NULL	Name of the materialized view
  MASTER_OWNER	VARCHAR2(30)		Owner of the master table
  MASTER	VARCHAR2(30)		Name of the master table
  LAST_REFRESH	DATE		The last refresh

  See Also: "DBA_MVIEW_REFRESH_TIMES" "USER_MVIEW_REFRESH_TIMES"