Top "Dblink" questions

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

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 …

oracle oracle11gr2 dblink
Oracle: Using a database link in a stored procedure : table or view does not exist

I currently have an issue whereby I cannot reference a table in a linked database within a stored procedure. I …

sql database oracle stored-procedures dblink
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 …

postgresql oracle11g postgresql-9.2 dblink
Installing DBLink for Postgres 9

Can someone please shed some light on how to install the requirements for Postgres 9 (Centos) to be able to use …

sql linux dblink postgresql
How do I do large non-blocking updates in PostgreSQL?

I want to do a large update on a table in PostgreSQL, but I don't need the transactional integrity to …

postgresql transactions sql-update plpgsql dblink
Oracle Syntax for Creating Database Link Owned by Another User

The typical syntax for creating a db link is as follows: create database link remote_db_link connect to remote_…

oracle owner dblink
How to use synonym of a DBlink in Oracle?

I have created a synonym for a dblink. create synonym dblink2 for dblink1 But when I query anything using the …

oracle dblink
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 …

java database oracle transactions dblink
ORA-02070: database does not support in this context

I have a query like INSERT INTO sid_rem@dev_db (sid) select sid from v$session Now, when i …

oracle dblink
Oracle 11gr2 connection to Sql Server using dg4msql problem

To whom it may respond to, We have installed Oracle 11g r2 on a Redhat Enterprise Linux 5.4 . We are trying …

sql-server-2005 oracle11g dblink heterogeneous