How to Capture From an Oracle Materialized View

Question

How can I capture from an Oracle materialized view?

Environment

HVR 5

Answer

HVR cannot replicate from a view in Oracle. However, it can do a log-based capture on Oracle materialized views.

A materialized view is a table that is periodically updated by Oracle using view definition.

In HVR, Table Select or Table Explore can select materialized views. Whenever a materialized view is updated, it is replicated as a normal table.

On the target, the content of the materialized view is replicated to a regular table.