DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.ALL_REFRESH_DEPENDENCIES

Object Details
Object Name: ALL_REFRESH_DEPENDENCIES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Description of the detail tables that materialized views depend on for
refresh

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the dependent table
TABLE_NAME VARCHAR2 (128) Yes Name of the dependent table
PARENT_OBJECT_TYPE CHAR (17)
Materialized View
OLDEST_REFRESH_SCN NUMBER

The oldest scn of a dependent materialized view
OLDEST_REFRESH_DATE DATE

The oldest date scn of a dependent materialized view
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      TABLE_NAME
,      PARENT_OBJECT_TYPE
,      OLDEST_REFRESH_SCN
,      OLDEST_REFRESH_DATE
FROM SYS.ALL_REFRESH_DEPENDENCIES;

Dependencies

[top of page]

SYS.ALL_REFRESH_DEPENDENCIES references the following:

SchemaSYS
TableOBJ$
TableOBJAUTH$
TableSNAP_LOADERTIME$
TableSUM$
TableSUMDEP$
TableUSER$
SYS.ALL_REFRESH_DEPENDENCIES is referenced by following:

SchemaPUBLIC
SynonymALL_REFRESH_DEPENDENCIES