SV: Need SQL to connect remotely

Doris,

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_at_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');

commit;

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_at_AUDV);

commit;

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

Regards
Jesper Haure Norrevang

-----Oprindelig meddelelse-----
Fra: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] P=E5 vegne af Goodson, Doris
Sendt: 11. januar 2005 02:38
Til: oracle-l_at_freelists.org
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 = another
database.

Any ideas how to do this through sql worksheet session?

Thanks,
Doris Goodson

 =20

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l