How to capture from an Oracle Materialized view

This topic contains 0 replies, has 1 voice, and was last updated by  Frank Knot 1 week, 1 day ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #8758

    Frank Knot
    Participant

    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.

© 2017 HVR Software

Free Trial Contact Us