Top "Dblink" questions

Referencing Oracle user defined types over DBLINK?

I'm working in two different Oracle schemas on two different instances of Oracle. I've defined several types and type collections …

oracle types collections dblink

Run SQL Server Stored Procedure via Database Link from Oracle

Referring to How to execute an Oracle stored procedure via a database link, it does not work in my case. …

oracle sql-server-2008 dblink

Is there any shortcut for using dblink in Postgres?

In Postgres, you can link to your other databases using dblink, but the syntax is very verbose. For example you …

postgresql syntax dblink cross-database

PostgreSQL dblink with named connections

dblink does not seem to work when I use a named connection to a remote server or an unnamed connection …

postgresql session connection dblink

How to connect to remote database through DB link using JDBC?

I need to connect to a remote database using Database link using JDBC commands. How can it be done?

java jdbc dblink

oracle - commit over dblink?

If I connect to an oracle database as user smith, and issue the following 3 commands: update smith.tablea set col_…

sql database oracle commit dblink

postgres dblink escape single quote

Related Link: String literals and escape characters in postgresql Here is my error: ERROR: type "e" does not exist Here …

sql postgresql escaping dblink

ERROR: function dblink(unknown, unknown) does not exist

I have defined a foreign server pointing to another database. I then want to execute a function in that database …

postgresql dblink

How to create Oracle database link with sysdba privilege

I want to: select * from v$database@standby; Problem: standby is mounted so only a SYSDBA user can connect to …

oracle oracle-apex dblink

postgresql slow query (dblink and inner join)

I have this query containing a dblink since I need to connect to another database and it seems so slow (50.343 …

database performance postgresql inner-join dblink