SV: Need SQL to connect remotely

  • From: Jesper Haure Norrevang <jhn.aida@xxxxxx>
  • To: DGoodson@xxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 11 Jan 2005 09:20:56 +0100


I have never claimed, that I am an expert, but
I will try to answer anyway.

What you need is a DATABASE LINK. The idea is
that you with some restrictions can reference
a remote table, e.g. test@AUDV, just as if it
were a local table.

I have made a quick and dirty test:

On remote database

drop table test;

create table test
(c  varchar2(40));

insert into test values
('This is remote data');


On local database

create database link AUDV
connect to jhn
identified by remotepass
using 'AUDV';

create table localtab
(c varchar2(40));

insert into localtab values
('This is local data');

update localtab
set c =3D (select c
         from test@AUDV);


I hope this gives you an idea of
how it is working.

Jesper Haure Norrevang

-----Oprindelig meddelelse-----
Fra: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] P=E5
vegne af Goodson, Doris
Sendt: 11. januar 2005 02:38
Til: oracle-l@xxxxxxxxxxxxx
Emne: Need SQL to connect remotely

I was wondering if any SQL experts are on the list.
I need to update a field in my current database with a field from =

Any ideas how to do this through sql worksheet session?

Doris Goodson




Other related posts:

  • » SV: Need SQL to connect remotely