Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
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 |