ALL_MVIEW_LOGS

ALL_MVIEW_LOGS describes all materialized view logs accessible to the current user.

Related Views

• DBA_MVIEW_LOGS describes all materialized view logs in the database.
• USER_MVIEW_LOGS describes all materialized view logs owned by the current user.

  Column	Datatype	NULL	Description
  LOG_OWNER	VARCHAR2(30)		Owner of the materialized view log
  MASTER	VARCHAR2(30)		Name of the master table or master materialized view whose changes are logged
  LOG_TABLE	VARCHAR2(30)		Name of the table where the changes to the master table or master materialized view are logged
  LOG_TRIGGER	VARCHAR2(30)		Obsolete with the release of Oracle8i and higher. Set to NULL. Formerly, this parameter was an after-row trigger on the master which inserted rows into the log.
  ROWIDS	VARCHAR2(3)		If YES, records rowid information
  PRIMARY_KEY	VARCHAR2(3)		If YES, records primary key information
  OBJECT_ID	VARCHAR2(3)		If YES, records object identifier information in an object table
  FILTER_COLUMNS	VARCHAR2(3)		If YES, records filter columns
  SEQUENCE	VARCHAR2(3)		If YES, records the sequence value, which provides additional ordering information
  INCLUDE_NEW_VALUES	VARCHAR2(3)		If YES, records both old and new values. If NO, records old values, but does not record new values.

  See Also: "DBA_MVIEW_LOGS" "USER_MVIEW_LOGS"