Static Data Dictionary Views, 70 of 452

ALL_REFRESH_DEPENDENCIES

ALL_REFRESH_DEPENDENCIES lists the names of the dependent detail or container tables of all the summaries or snapshots 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)`		'`SNAPSHOT`' or '`SUMMARY`'
`OLDEST_REFRESH_SCN`	`NUMBER`		The minimum SCN of any summary or snapshot that has `TABLE_NAME` as a detail table
`OLDEST_REFRESH_DATE`	`DATE`		`SYSDATE` when last refreshed