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
10
votes
2 answers

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_name = 'florence' where col_id = 8; insert into bob.other_table@mylink values ('blah',2,'uncle','new'); commit; Does this mean that…
toop
  • 10,834
  • 24
  • 66
  • 87
10
votes
1 answer

How do i create postgres to oracle dblink?

How do I create dblink in postgres 9.2 ? I want to be able to use it using @ link in oracle? I am using postgres 9.2 64bit. DBlink is from postgres 9.2 to Oracle 11g.
kinkajou
  • 3,664
  • 25
  • 75
  • 128
9
votes
1 answer

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 and disconnect. It works fine if I use an unnamed connection with a connection string in dblink(). It appears to connect fine, but my connection…
bendiy
  • 595
  • 1
  • 7
  • 15
9
votes
1 answer

dblink does not exist even when the extension already exists?

So I'm new to using dblink, I just created a script that inserts data into a table from another database. I received the error function dblink(unknown,unknown) does not exist. So I checked online, and used CREATE EXTENSION dblink, ended up getting…
Joshua Rajandiran
  • 2,788
  • 7
  • 26
  • 53
9
votes
6 answers

Select and Insert across dblink

I am having a bit of trouble with a select into insert across a dblink in oracle 10. I am using the following statement: INSERT INTO LOCAL.TABLE_1 ( COL1, COL2) SELECT COL1, COL2 FROM REMOTE.TABLE1@dblink s WHERE COL1 IN ( SELECT COL1 FROM…
Domtar
  • 91
  • 1
  • 1
  • 2
7
votes
1 answer

ORA-02085: database link DBLINK_NAME connects to ORACLE

I m having a database by name 'HBHAWANI' on my domain server name 'HBHAWANI' (version Oracle 8i). Whenever I try to create a dblink here it gives the error : Link : "DBLINK_DOMAINSERVERTOUPASS_PP" Error : ORA-02085: database link…
MAHESH A SONI
  • 81
  • 1
  • 1
  • 3
7
votes
1 answer

How can I get the column names of a table referred by a dblink?

I am new to oracle. I have a table referred using a dblink, say MY_TABLE@MY_DBLINK. Suppose MY_TABLE has columns like COLUMN_1, COLUMN_2. How can I write a query to return the column names? I tried to use DESCRIBE MY_TABLE@MY_DBLINK. But it is…
988875
  • 1,477
  • 3
  • 12
  • 12
6
votes
4 answers

When establishing access to data on a remote database, are views or synonyms preferred?

Consider a scenario where you have two databases: On database A you need to access data on database B. You could create a view on database A that selects from the table on database B. CREATE OR REPLACE VIEW Demographics.Employees( employee_id,…
Jeromy French
  • 11,812
  • 19
  • 76
  • 129
6
votes
4 answers

Error on Oracle while using DBLINK

I am Using jboss5.1.x, EJB3.0 ,JPA3. I am trying to do 'select' query from view which is connected via dblink to another database. source database is Oracle 9, destination dabatase is Oracle 8. I am getting this error: 15:27:06,625 WARN…
rayman
  • 20,786
  • 45
  • 148
  • 246
6
votes
2 answers

DBLINK vs Postgres_FDW, which one may provide better performance?

I have a use case to distribute data across many databases on many servers, all in postgres tables. From any given server/db, I may need to query another server/db. The queries are quite basic, standard selects with where clauses on standard…
Mark Giaconia
  • 3,844
  • 5
  • 20
  • 42
6
votes
1 answer

PostgreSQL 9.5: Hide password from dblink connection

I want to you table which is located in the other database. I am using the dblink for this. Procedure: Step 1: Created extension. CREATE EXTENSION dblink; Step 2: Making dblink connection string. select dblink_connect('con','host=127.0.0.1…
MAK
  • 6,824
  • 25
  • 74
  • 131
6
votes
1 answer

Hibernate with oracle dblink implementation

Just new with hibernate, is there a way to implement oracle dblink on hibernate? e.g. select * from tablename@dblink to be used in hql?
user2640305
  • 71
  • 4
5
votes
2 answers

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 query it I can't find out how to use a database link using SYSDBA privilege My goal is to display system information/stats from a…
CamilleHuot
  • 105
  • 1
  • 1
  • 6
5
votes
2 answers

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 can do: SELECT * FROM dblink ( 'dbname=name port=1234 host=host user=user password=password', 'select * from table' ) AS…
Joe
  • 7,922
  • 18
  • 54
  • 83
5
votes
3 answers

Does Amazon Redshift support extension dblink?

CREATE EXTENSION dblink; I tried to create an extension dblink in AWS, but I receive this error. ERROR: syntax error at or near "EXTENSION" LINE 1: create extension dblink;
Reece Mak
  • 101
  • 2
  • 9
1
2
3
…
34 35