dblink Archives

Postgresql MVIEW refresh from Oracle Materialized View Log

By adminPosted on January 14, 2023

Question : Is it possible for me to have Oracle MVIEW log in my source database and refresh a Postgresql […]

By adminPosted on January 9, 2023

Question : I have administrator access to our Oracle database , but was wondering if its possible to connect an […]

By adminPosted on January 8, 2023

Question : I have the environment that I explain below and I need to encrypt the data that is sent […]

By adminPosted on December 22, 2022

Question : I have a production database “PRODdb1”, with a read-only user account. I have a need to query(select statement) […]

By adminPosted on November 1, 2022

Question : we have an SSIS job that inserts data into a table in server A from data in table […]

By adminPosted on October 18, 2022

Question : I have created a Heterogeneous connection between oracle and sql server. and tested with below query, SELECT * […]

By adminPosted on September 17, 2022

Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]

By adminPosted on September 8, 2022

Question : I have a view that I can access through a database link as such: SQL> select count(*) from […]

By adminPosted on September 4, 2022

Question : I’m using the SAMPLE clause to retrieve random rows from a table. It works fine except when the […]

By adminPosted on April 13, 2022

Question : We have a database link from Oracle 12.1 to Postgres via psqlODBC Driver. There is a problem while […]