Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can Transparent Gateways be used for Heterogeneous Replication?

April 26, 2017gateways Heterogeneous replication transparent Used

0

10 Posted

Can Transparent Gateways be used for Heterogeneous Replication?

1 Answer

0

Posted

All of our Transparent Gateway products from v8.1.6 onwards support read-only complete refresh materialized views (snapshots). You can create the Oracle snapshot by issuing the standard replication SQL: CREATE MATERIALIZED VIEW mv_name REFRESH COMPLETE AS query; where query represents the data you want to retrieve from the non-Oracle system. Multiple MVs are grouped together in a refresh group by the following statement: execute dbms_refresh.make(‘groupname’, ‘list_of_MVs’, NULL, NULL); and can be refreshed by: execute dbms_refresh.refresh(‘groupname’); If you want the refresh to be done at regular intervals you can setup a database job for this. Please refer to the replication manual for more details on the replication SQL syntax and related procedures. Another way to replicate data is by setting trigger(s) on the Oracle tables which you want to replicate to the non-Oracle system. When a change occurs in the Oracle table the trigger fire thus ‘replicating’ the change to the non-Oracle