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