Hello,

I'm trying to write a query that on one server will link to another server's table. For example, say I have two environments, TRN and DEV, and I want in TRN to have my query connect to a table in development. How do I do that?

Something like:

select *
from mySchema.Table1 t
left outer join DEV.mySchema.Table1 d
on t.ID = d.ID

something like that?

Brian

__________________
Brian

Create a database link called TRN from DEV. like,

create database link TRN connect to mySchema identified by <password> using 'TNS_STR';-- create a TNS string and put the name here.

then you can select using,

select *
from mySchema.Table1 t
left outer join Table1@TRN d
on t.ID = d.ID




Sujit Ku. Mahapatra