from sql server to oracle to ANOTHER oracle

From: Alberto Marchi <alberto.roller_at_gmail.com>
Date: Thu, 10 Nov 2011 07:57:12 -0800 (PST)
Message-ID: <d5f7fb2e-0852-4a38-b1ee-4f8d172b22e7_at_r28g2000yqj.googlegroups.com>



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! Received on Thu Nov 10 2011 - 09:57:12 CST

Original text of this message