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
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@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@AUDV);
commit;
I hope this gives you an idea of
how it is working.
Regards
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 =
another
database.
Any ideas how to do this through sql worksheet session?
Thanks,
Doris Goodson
=20
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » SV: Need SQL to connect remotely
