Table: ALL_BASE_TABLE_MVIEWS
All materialized views with log(s) in the database that the user can see
Column Name | Description |
---|---|
MASTER | Name of the master table which changes are logged |
MVIEW_ID | Unique identifier of the materialized view |
MVIEW_LAST_REFRESH_TIME | One date per materialized view -- the date the materialized view was last refreshed |
OWNER | Owner of the master table which changes are logged |