../E40402-16.epub /> ../E40402-16.mobi />

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   SYSDATE from the master site at the time of the last refresh