Go to main content

25 Materialized View and Refresh Group Views

This chapter lists the following data dictionary views, which provide information about materialized views and materialized view refresh groups.

ALL_ Views	DBA_ Views	USER_ Views
`ALL_BASE_TABLE_MVIEWS`	`DBA_BASE_TABLE_MVIEWS`	`USER_BASE_TABLE_MVIEWS`
N/A	`DBA_MVIEW_LOG_FILTER_COLS`	N/A
`ALL_MVIEW_LOGS`	`DBA_MVIEW_LOGS`	`USER_MVIEW_LOGS`
`ALL_MVIEW_REFRESH_TIMES`	`DBA_MVIEW_REFRESH_TIMES`	`USER_MVIEW_REFRESH_TIMES`
`ALL_MVIEWS`	`DBA_MVIEWS`	`USER_MVIEWS`
N/A	`DBA_RCHILD`	N/A
`ALL_REFRESH`	`DBA_REFRESH`	`USER_REFRESH`
`ALL_REFRESH_CHILDREN`	`DBA_REFRESH_CHILDREN`	`USER_REFRESH_CHILDREN`
`ALL_REGISTERED_MVIEWS`	`DBA_REGISTERED_MVIEWS`	`USER_REGISTERED_MVIEWS`
N/A	`DBA_RGROUP`	N/A

See Also:

Oracle Database Reference for more information about these views
Chapter 10, "Monitoring a Replication Environment" for example queries that use some of these views