Home Oracle Commands Oracle Data Dictionary
 v$ Performance views

ALL_MVIEW_LOGS

All materialized view logs in the database that the user can see 

Columns
   ___________________________
 
   MASTER
      Name of the master table which changes are logged
   LOG_TABLE
      Log table; with rowids and timestamps of rows which changed in the master ALL_MVIEW_LOGS
   ROWIDS
      If YES,the materialized view log records rowid information
   PRIMARY_KEY
      If YES,the materialized view log records primary key information
   OBJECT_ID
      If YES,the materialized view log records object id information
   FILTER_COLUMNS
      If YES,the materialized view log records filter column information
   SEQUENCE
      If YES,the materialized view log records sequence information
   INCLUDE_NEW_VALUES
      If YES,the materialized view log records old and new values (else only old values)

Related:


Simon Sheppard
SS64.com