Materialized Views in OGG to MSSQL Target — oracle-tech

    Forum Stats

  • 3,714,736 Users
  • 2,242,615 Discussions
  • 7,845,036 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Materialized Views in OGG to MSSQL Target

User_5Y70F
User_5Y70F Member Posts: 25 Red Ribbon

Hi Guys,

SOURCE:

Oracle 12c

OGG 12.3

Oracle Linux 7 x64

TARGET:

MSSQL 2014 Std

OGG 12.3

Windows Server 2016

The client is trying to simplify the data set that is replicated to the MSSQL Target. They have created a Materialized View and they wish to ONLY replicate this MV, and NO underlying tables at all. Is it possible to replicate the resultant dataset of an MV on its own, wiht no other tables?

Thanks.

Tagged:
Sign In or Register to comment.