Re: dblink and tnsname

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Thu, 25 Jul 2002 11:02:26 +0100
Message-ID: <R0Q%8.4680$zX3.4128@news.indigo.ie>

If you are set up correctly should execute at db2 and return the result to db1
will execute at db2

92 Administrators Guide Part VI Distributed databases has what you need.

"xueyang" <xueyangy_at_singnet.com.sg> wrote in message news:ahodm3$90e$1_at_reader02.singnet.com.sg...
> Thanks for the reply. Ok, let make my question clear.
>
> conditions:
> db1 on svr1, db2 on svr2.
>
> Now i want to issue such a query on svr1 : select sum(fld1) from
> table1(table1 resides on db2)
> there are two ways to do this:
> 1.
> login to db1 first using sqlplus
> then issue the query select sum(fld1) from table1_at_dblink1(dblink1
connects
> to db2)
>
> 2,
> login to db2 directly on svr1 by tnsname
> sqlplus userid_at_tnsname/passwd
> then issue the query select sum(fld1) from table1.
>
> My question is: which server's meory the query is going to take for each
> way? method 1, svr1 or svr2? method 2, svr1 or 2?
>
> Btw, Do u know where can i find such topic in documentation?
>
> Thanks in advance,
>
>
>
>
Received on Thu Jul 25 2002 - 05:02:26 CDT