RE: Need SQL to connect remotely

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Tue, 11 Jan 2005 09:37:17 -0500
Message-ID: <001701c4f7eb$0cc2ba40$8459000a@vttaxnet.tax.state.vt.us>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Goodson, Doris Sent: Monday, January 10, 2005 8:38 PM
To: oracle-l_at_freelists.org
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

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 11 2005 - 08:38:26 CST