On Wed, Nov 23, 2011 at 4:47 PM, Powell, Mark <mark.powell2@xxxxxx> wrote: > On the database you are connecting to you would create a database link to the > remote database and then either reference the link in the sub-select or > create a synonym for the remote object that provides the link: > > Select testfield from test2@remote Thaks Mark. CREATE DATABASE LINK local CONNECT TO hr IDENTIFIED BY password USING 'local'; After this database link is created, hr can query tables in the schema hr on the local database in this manner: SELECT * FROM employees@local; http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_5005.htm cheers Sven -- //www.freelists.org/webpage/oracle-l