ALL_BASE_TABLE_MVIEWS

ALL_BASE_TABLE_MVIEWS lists information about all materialized views using materialized view logs accessible to the current user. A materialized view log can be created for a master or base table or a master materialized view. Query this view at the master site or master materialized view site to show one row for each materialized view using a materialized view log.

Related Views:

• DBA_BASE_TABLE_MVIEWS describes all materialized views using materialized view logs in the database.

• USER_BASE_TABLE_MVIEWS describes all materialized views using materialized view logs owned by the current user.

  Column	Datatype	NULL	Description
  OWNER	VARCHAR2(30)	NOT NULL	Schema in which the master table or master materialized view was created
  MASTER	VARCHAR2(30)	NOT NULL	Name of the master table or master materialized view
  MVIEW_LAST_REFRESH_TIME	DATE	NOT NULL	The date when the materialized view based on the master was last refreshed
  MVIEW_ID	NUMBER(38)		Unique identifier of the materialized view that is based on the master