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@ORAGATE2

but it does not work

questions
1) is is possible to use nested dblinks ?
2) if so, how ?

thank you!

On Nov 10, 10:57*am, Alberto Marchi <alberto.rol... (AT) gmail (DOT) com> wrote:


use a synonym that points to the second linked table?

On Nov 10, 9:27*pm, onedbguru <onedbg... (AT) yahoo (DOT) com> wrote:
This is what we have done when going from one Oracle to another non-
sqlnet compatable version, that is, from Oracle_1 we reference an
object in Oracle_2 which is actuall just a remote synonym to Oracle_3.

If this will not work with SQL Server via ODBC/OLE then try replacing
the synonyms in the middle Oracle with views that reference the
objects in the second Oracle.

HTH -- Mark D Powell --