Re: from sql server to oracle to ANOTHER oracle

From: onedbguru <onedbguru_at_yahoo.com>
Date: Thu, 10 Nov 2011 18:27:48 -0800 (PST)
Message-ID: <94eceb84-6aec-4a44-94c6-3d871ed836a8_at_x7g2000yqb.googlegroups.com>



On Nov 10, 10:57 am, Alberto Marchi <alberto.rol..._at_gmail.com> wrote:
> I have a linked server to a oracle db, that works.
>
> I have to write a query from sql server that connecto to the oracle
> server, and the use a database link from that oracle db to another
> oracle db. I'm not able to find the syntax.
>
> I try to write something like
>
>  SELECT * FROM
>   LINKTOORACLE..mm510TAL.CSHDET_at_ORAGATE2
>
> but it does not work
>
> questions
> 1) is is possible to use nested dblinks ?
> 2) if so, how ?
>
> thank you!

use a synonym that points to the second linked table? Received on Thu Nov 10 2011 - 20:27:48 CST

Original text of this message