Your browser does not support JavaScript. This help page requires JavaScript to render correctly.
Previous
Previous
 
Next
Next

Writeable Materialized Views

You can create a materialized view using the FOR UPDATE clause during creation but then never add the materialized view to a materialized view group. In this case, users can perform data manipulation language (DML) changes to such a materialized view, but these changes cannot be pushed back to the master and are lost if the materialized view refreshes. Such materialized views are called writeable materialized views.

Related Topics

Flowchart for Creating a Replication Environment

What Is Materialized View Replication?

Replication Objects

Replication Groups

Replication Sites