Can I create materialized Oracle views for sqllink SQL Server table?

Question

I have a table in a SQL Server database that should be visible in the oracle database. We tried using the normal view over sqllink, but we cannot create onUpdate triggers in this view.

I read that we can create a trigger if it is a materialized representation, but cannot find any information on whether this can be done in different databases. (all example for oracle and oracle tables)

Can someone tell me if this is possible? and what problems may I need if I use materialized ideas?

thank

Answer 1

I do something similar and end up using the Oracle HS gateway to handle it. Created MV based on tables or queries to create staging area in Oracle. Logic followed to satisfy requests.