How to capture from an Oracle Materialized view

Viewing 1 post (of 1 total)
  • Author
  • #8758
    Frank Knot

    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.

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.

© 2020 HVR

Try Now Contact us