ALL_REFRESH_DEPENDENCIES

ALL_REFRESH_DEPENDENCIES displays the names of the dependent detail or container tables of all the materialized views in the current schema.


Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the table

TABLE_NAME

VARCHAR2(128)

NOT NULL

Table name, unique within this schema

PARENT_OBJECT_TYPE

CHAR(17)

 

MATERIALIZED VIEW

OLDEST_REFRESH_SCN

NUMBER

 

Minimum SCN of any summary or materialized view that has TABLE_NAME as a detail table

OLDEST_REFRESH_DATE

DATE

 

SYSDATE when last refreshed