Question : Is it possible for me to have Oracle MVIEW log in my source database and refresh a Postgresql […]
Tag: dblink
Connecting Oracle 11g to Postgres via dblink
Question : I have administrator access to our Oracle database , but was wondering if its possible to connect an […]
How to Oracle DBLink encryption
Question : I have the environment that I explain below and I need to encrypt the data that is sent […]
Can I use postgres_fdw without foreign tables defined?
Question : I have a production database “PRODdb1”, with a read-only user account. I have a need to query(select statement) […]
Alternatives for Dblink in oracle?
Question : we have an SSIS job that inserts data into a table in server A from data in table […]
Unable to access tables in sql server using oracle dblink
Question : I have created a Heterogeneous connection between oracle and sql server. and tested with below query, SELECT * […]
What is a DB Link good for? [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Oracle 12c – Create materialized view results in ORA-00942
Question : I have a view that I can access through a database link as such: SQL> select count(*) from […]
Results of SAMPLE clause using a DBlink between 2 Oracle databases not randomised
Question : I’m using the SAMPLE clause to retrieve random rows from a table. It works fine except when the […]
Issue with Identifiers in Postgres greater than Oracle’s limit while connecting over ODBC (DBLINK)
Question : We have a database link from Oracle 12.1 to Postgres via psqlODBC Driver. There is a problem while […]