[Home] [Help] [Dependency Information]
Object Name: | CDB_MVIEW_REFRESH_TIMES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All fast refreshable materialized views and their last refresh times for each master table in all containers
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 | ||
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, NAME
, MASTER_OWNER
, MASTER
, LAST_REFRESH
, CON_ID
FROM SYS.CDB_MVIEW_REFRESH_TIMES;
SYS.CDB_MVIEW_REFRESH_TIMES does not reference any database object
SYS.CDB_MVIEW_REFRESH_TIMES is referenced by following:
|
|
|