Postgresql MVIEW refresh from Oracle Materialized View Log
0
votes
2
answers
707
views
Is it possible for me to have Oracle MVIEW log in my source database and refresh a Postgresql database MVIEW using this MVIEW log? I know I can query the MVIEW log, I have done that. But since it is not a good practice to query a log, is it even possible to use an MVIEW log from Postgresql just like an Oracle MVIEW uses a log?
If that's not possible, is a dblink from Postgresql to Oracle possible?
Asked by MacJava
(1 rep)
Apr 23, 2020, 01:33 PM
Last activity: Apr 19, 2025, 06:04 AM
Last activity: Apr 19, 2025, 06:04 AM