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.
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