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
0
votes
1 answer

How can I create a dblink from Postgresql 8.3 to SQL Server (2000 and 2008)?

I have a Postgresql database that need to read data from two SQL Servers (one SQL Server 2000 and one SQL Server 2008). I want to setup two dblinks to the SQL Servers. After googling, foruming, reading documentation, I struggle to find something…
Stephan
  • 41,764
  • 65
  • 238
  • 329
0
votes
1 answer

Oracle CLOB to varchar2 over DBLINK

I have to migrate a database to another. I have a dblink to make it easyier. Know I try to copy the colum comments and description from a table. The Problem is that the type is a CLOB. In the new database I use VARCHAR2. I used a workaround and…
John Smithv1
  • 673
  • 5
  • 14
  • 33
0
votes
2 answers

Is it possible to programmatically create a DBLink in SQL server 2005 in C#?

Is it possible to programmatically create a DBLink in SQL server 2005 in C#? Suppose I have database A and B. I want to create a DBlink in A to connect B. I will capture the B database info from user and create the DBLink in database A. Is this…
Bhushan Bhangale
  • 10,921
  • 5
  • 43
  • 71
0
votes
1 answer

Postgresql dblink

Trying to be lazy when looking at an example SELECT realestate.address, realestate.parcel, s.sale_year, s.sale_amount, FROM realestate INNER JOIN dblink('dbname=somedb port=5432 host=someserver …
Thorne
  • 63
  • 2
  • 8
-1
votes
1 answer

Alter session "on calling" a query via Oracle DB-Link

I have a problem with a remote database and a functional index. When I call a query on a DB link from databases with "normal index", this DB passes the session parameters from the database that calls the DB link. But I need the session parameters…
Georg
  • 1
  • 1
-1
votes
1 answer

FireDAC: possibility to make query faster - Delphi

I use bind variables in Delphi and on the other side there is Oracle database with Database link (@dblink). When I build a SELECT statement without bind variables, it has no problem with performance. Only if I query SELECT statement with bind…
Niko
  • 69
  • 7
-1
votes
1 answer

Oracle DB to Oracle DB Connection Connection forward

I have a question regarding oracle DB's. Consider we have an Oracle Database A and it has a DR named B. For patching and other changes, some times DB A/B has a downtime. Few of our clients are correcting to A and few of them are connecting to…
VSR
  • 1
-1
votes
1 answer

I am trying to connect from Oracle to other database like PostgreSQL using Heterogeneous Database connections

The error I am getting is ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from PG_LINK 28545. 0000 - "error diagnosed by Net8 when connecting to an…
Unmesh sawant
  • 11
  • 1
-1
votes
1 answer

DB link in postgres looking at another localhost image : relation tablename does not exist

i'm using docker to host two different postgresql instances to try and produce a proof of concept for python as an etl to move data between the two i can connect to the one via python fine but then when calling a procedure inside the first instance…
jwolverson
  • 67
  • 8
-1
votes
1 answer

How to Create DB links in Postgres for Virtual Columns in a table?

I have an Oracle Query as follows that uses a dblink, SELECT * FROM SSP2_PCAT.PRODUCT_TYPES WHERE ( PRODUCT_TYPE) IN (SELECT PRODUCT_TYPE FROM SSP2_PCAT.PRODUCT_TYPES MINUS SELECT PRODUCT_TYPE FROM SSP2_PCAT.PRODUCT_TYPES@FPORDDEV); Now I…
user10531062
  • 177
  • 1
  • 4
  • 18
-2
votes
1 answer

Error in creating a DBLINK Oracle to SQL Server

I'am create DBLINK the Oracle(11gR2)(Windows Server 2008) to SQL Server(Windows 10). I have Oracle Gateway installed. I created a font of data in ODBC Data Source Administrator and a connection is Ok. His name is Integra. I altered the files…
dba
  • 1
  • 1
-2
votes
1 answer

C# linq and multilingual database

In my application has a multilingual database. It is necessary to load the lists from the database of the language which is set in the user program. I use Dbling library and now 3 days scratching their heads, how to dynamically take the data from a…
murash
  • 211
  • 3
  • 14
-2
votes
1 answer

Install only dblink module from postgresql-contrib package in centOS

I would like to install only the dblink module from postgresql-contrib package. I use the command as below zypper install postgres-contrib But it installs everything. Is there a way to install a specific module.
Somali Batra
  • 81
  • 4
1 2 3
…
34
35