ALL_REFRESH_DEPENDENCIES lists the names of the dependent detail or container tables of all the materialized views in the current schema.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the table |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Table name, unique within this schema |
PARENT_OBJECT_TYPE |
CHAR(17) |
MATERIALIZED VIEW |
|
OLDEST_REFRESH_SCN |
NUMBER |
The minimum SCN of any summary or materialized view that has TABLE_NAME as a detail table |
|
OLDEST_REFRESH_DATE |
DATE |
SYSDATE when last refreshed |