Stack Overflow
Stack Overflow

Questions tagged [dblink]

An object or module that enables access to a remote database.

In Oracle a database link is a schema-level object that enables users to access objects on a remote database. It is possible to create a database link to access a non-Oracle database.

In PostgreSQL dblink is a module, which enables connections to other PostgreSQL databases, from within a session.

Questions tagged should also be tagged with the appropriate RDBMS.

523 questions
3
votes
2 answers

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 to transfer data between these schemas. The problem I'm running into is that even though the type have exactly the…
ScottCher
  • 14,651
  • 6
  • 26
  • 25
3
votes
3 answers

Postgres, plpgsql: Is there a way to connect to other DB from inside of a stored procedure?

I have two DB's one is feed by filtered data from another, now i'm using perl script witch executes query on foreign DB, stores a result in a csv file, and loads it to local DB using \COPY sytnatx Is there a way to write plpgsql function witch will…
canni
  • 5,737
  • 9
  • 46
  • 68
3
votes
1 answer

Postgres: Using dblink to make remote connection

We got a Postgres database credentials (with SSL on) from our contractor, which allow us to connect to the DB using pdAdmin 3. The DB is read-only (can't do pg_dump) to us and basically the contractor will not grant us more privileges. We need to…
nigong
  • 1,727
  • 3
  • 19
  • 33
3
votes
1 answer

Is it possible to connect to DB in Oracle APEX application externally?

I am trying to query the table stored in Oracle APEX application externally (using Java). But, i am quite not sure on achieving it. Because, inside APEX i was able to access external databases using dblink. But, the other way around is puzzling me.…
bprasanna
  • 2,423
  • 3
  • 27
  • 39
3
votes
3 answers

How to extract ddl for oracle db links?

Is there anyway to extract ddl for all database links? I would like to get in sql and recreate them via sql. I can use below and it works for PUBLIC user but for non public user it doesn't give me db link owner. Set long 1000 SELECT…
homer
  • 423
  • 2
  • 11
  • 24
3
votes
1 answer

Oracle create db link using a proxy schema

So I want to create a database link in oracle, my username is jefferson and I want to connect trough opms so I was told to do this. create database link tmpp connect to jefferson[opms] identified by nothing using $something ; For some reason…
Gleiry Agustin Serrano Wong
  • 73
  • 1
  • 4
3
votes
1 answer

PL/SQL set a link as default at the begining of the script

I need to select a link at the beginning in the script. Usually we do select links as below, begin select * from v$database@linkname; end; But now I need to select the link at the beginning something like this, begin select_link 'linkname'; select…
Janitha Madushan
  • 1,453
  • 3
  • 28
  • 40
3
votes
3 answers

Why does Char(1) change to Char(3) when copying over an Oracle DBLINK?

I have 2 databases, and I want to transport an existing table containing a CHAR column from database A to database B. Database A is Oracle 9i, has encoding WE8ISO8859P1, and contains a table "foo" with at least 1 column of type CHAR(1 char). I can…
Rolf
  • 7,098
  • 5
  • 38
  • 55
3
votes
1 answer

How to use dblink_connect and dblink_connect_u

I have two databases in Postgres and want to access the data from one database to other database tables. I tried the following: dblink_connect('myconn','hostaddr=10.10.30.53 dbname=postgres user=postgres…
Rama
  • 31
  • 1
  • 1
  • 3
3
votes
1 answer

Copy data between two tables in PostgreSQL using dblink.sql

I am using PostgreSQL 9.1. I need to transfer required columns from one table of one database into another table of another database, but not schema. I found that dblink.sql file has to be there in share/contrib. But my contrib folder is empty.…
user1915182
  • 81
  • 2
  • 4
3
votes
3 answers

MySQL equivalent of PostgreSQL's dblink module?

PostgreSQL's dblink module allows for SQL statements to be written that execute other SQL statements against a remote PostgreSQL database. Is there an equivalent to PostgreSQL's dblink for MySQL?
user145420
  • 31
  • 2
3
votes
3 answers

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?
Nigel Thomas
  • 1,881
  • 8
  • 30
  • 50
3
votes
1 answer

What are the possible problems bound to a DB Link in a production environment?

In the company I work for the DB experts says a DB Link is really dangerous. I couldn't understand why. The entire network is protected I believe it's not a security problem. Is any severe problem affecting DBLink?
Revious
  • 7,816
  • 31
  • 98
  • 147
3
votes
1 answer

Is it possible to use a database link between an oracle database and a postgresql database on different physical servers

I've trying to streamline an intranet application where some of the data is stored locally on the postgresql database of the intranet server and other related data is stored in our enterprise oracle 10g2r2 database. What I would like to do is…
Tim Ashman
  • 65
  • 3
  • 6
2
votes
1 answer

How to setup a dblink from Oracle 10gR2 on Linux RedHat 64bit to Postgresql 8.3 on Linux RedHat 64bit too?

I try this query from Oracle : select * from "a_table"@Postgres; Here is the error message I get : ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: précédant 2 lines de…
Stephan
  • 41,764
  • 65
  • 238
  • 329
1 2 3
…
34 35