Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Static Data Dictionary Views, 81 of 521


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 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback