RE: Need SQL to connect remotely
- From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
- To: <DGoodson@xxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 11 Jan 2005 09:37:17 -0500
Create a link to the second database. If you create public synonyms on the
tables you need and put these into the first database, you can just access
the tables by name. We run an entire application from 1 database on another
using this method.
HTH,
Ruth
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Goodson, Doris
Sent: Monday, January 10, 2005 8:38 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
