[Home] [Help] [Dependency Information]
Object Name: | ALL_MVIEW_REFRESH_TIMES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Materialized views and their last refresh times for each master table that the user can look at
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Owner of the materialized view |
NAME | VARCHAR2 | (128) | Yes | The view used by users and applications for viewing the MV |
MASTER_OWNER | VARCHAR2 | (128) | Owner of the master table | |
MASTER | VARCHAR2 | (128) | Name of the master table | |
LAST_REFRESH | DATE | SYSDATE from the master site at the time of the last refresh |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, NAME
, MASTER_OWNER
, MASTER
, LAST_REFRESH
FROM SYS.ALL_MVIEW_REFRESH_TIMES;
|
|
|