Edit on GitHub
How to Capture From an Oracle Materialized Viewlink
Questionlink
How do I capture from an Oracle materialized view?
Environmentlink
HVR 5
Answerlink
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.