Materialized View Logs

Go Up to Supported Objects

Materialized View logs are tables that maintain a history of modifications to the master table, and they are used to refresh simple materialized views. When you create a materialized view log, Oracle automatically creates a log table to track data changes in the master table and a log trigger to maintain the data in the log table.

Creating and editing

• Materialized View Logs Wizard (Oracle) and Materialized View Logs Editor (Oracle)

DBMS platform availability and object actions/operations supported

The table below lists the platforms on which this object type is available. It also lists the object actions available against objects of this type For an introduction to object actions and details on usage of specific actions, see Object actions.

	ORCL
Drop	✓
Extract	✓
Migrate	✓
Report	✓
Shrink	✓