DBA_MVIEW_LOGS
All materialized view logs in the databaseColumns
___________________________
LOG_OWNER
Owner of the materialized view log
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
LOG_TRIGGER
An after-row trigger on the master which inserts rows into the log
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: