Online Documentation for SQL Manager for Oracle

Materialized View Logs


A Materialized view log is a table associated with the master table of a materialized view.

 

When DML changes are made to master table data, Oracle Database stores rows describing those changes in the materialized view log and then uses the materialized view log to refresh materialized views based on the master table.

 

Materialized View Log Editor allows you to define materialized view log properties. It opens automatically when you create a new materialized view log and is available on editing an existing one.

 

To open a materialized view log in Materialized View Log Editor, double-click it in the DB Explorer tree.