Static Data Dictionary Views, 116 of 666

ALL_REFRESH_DEPENDENCIES

ALL_REFRESH_DEPENDENCIES lists the names of the dependent detail or container tables of all the summaries or 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(7)`		`MVIEW` or `SUMMARY`
`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