Home Topics HVR Real-time Replicator Knowledge Base How to capture from an Oracle Materialized view
HVR is able to capture (log based) from an Oracle Materialized View. This type of view is actually just a table which is updated periodically by Oracle using the view definition.
To capture from such a view, its definition has to be entered manually (as a table) in the HVR catalogs. Table select / table explore currently only selects regular tables.
On the target, the contents of the materialized view will be replicated to a regular table.
You must be logged in to reply to this topic.
© 2019 HVR