Table: DBA_MVIEW_LOGS
All materialized view logs in the database
| Column Name | Description |
|---|---|
| FILTER_COLUMNS | If YES, the materialized view log records filter column information |
| INCLUDE_NEW_VALUES | If YES, the materialized view log records old and new values (else only old values) |
| LOG_OWNER | Owner of the materialized view log |
| 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 |
| MASTER | Name of the master table which changes are logged |
| OBJECT_ID | If YES, the materialized view log records object id information |
| PRIMARY_KEY | If YES, the materialized view log records primary key information |
| ROWIDS | If YES, the materialized view log records rowid information |
| SEQUENCE | If YES, the materialized view log records sequence information |