Top "Dblink" questions

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

postgresql: INSERT INTO ... (SELECT * ...)

I'm not sure if its standard SQL: INSERT INTO tblA (SELECT id, time FROM tblB WHERE time > 1000) What I'm …

sql postgresql insert dblink
How to SELECT in Oracle using a DBLINK located in a different schema?

We have an Oracle DBMS (11g) and the following configuration: A DB user "MYUSER" Two schemas "MYUSER" and "SCHEMA_B" …

database oracle database-schema dblink
How to create a DB link between two oracle instances

How to create a DB link between two Oracle instances. Let's say A and B are two instances. I want …

oracle dblink
How to use (install) dblink in PostgreSQL?

I am used to Oracle and to create a dblink in my schema and then access to a remote database …

sql postgresql dblink
Postgres Error: More than one row returned by a subquery used as an expression

I have two separate databases. I am trying to update a column in one database to the values of a …

sql database postgresql subquery dblink
How to check if a database link is valid in Oracle?

I have a main database with only setup data at the headquarter and several databases at different branches.I created …

oracle architecture dblink
PostgreSQL: Query has no destination for result data

I am trying to fetch data from remote db by using dblink through function but getting an error "query has …

postgresql common-table-expression dblink
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 …

oracle dblink
Testing DB Link - ORA-12154: TNS:could not resolve the connect identifier specified

I know there is a load of times this question has been asked but I can't quite figure out how …

database oracle oracle10g toad dblink
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 …

oracle insert dblink