Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.cambriumusenet.nl!feed.tweaknews.nl!postnews.google.com!u6g2000vbg.googlegroups.com!not-for-mail From: Mark D Powell Newsgroups: comp.databases.oracle.server Subject: Re: from sql server to oracle to ANOTHER oracle Date: Fri, 11 Nov 2011 12:28:39 -0800 (PST) Organization: http://groups.google.com Lines: 39 Message-ID: <5a87171d-fd09-4111-9d2c-1d4268d6dbaa@u6g2000vbg.googlegroups.com> References: <94eceb84-6aec-4a44-94c6-3d871ed836a8@x7g2000yqb.googlegroups.com> NNTP-Posting-Host: 15.219.153.74 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1321043436 25233 127.0.0.1 (11 Nov 2011 20:30:36 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 11 Nov 2011 20:30:36 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: u6g2000vbg.googlegroups.com; posting-host=15.219.153.74; posting-account=qJFqbQkAAACYQSLN0-cvP6ydkRfuOu6u User-Agent: G2/1.0 X-Google-Web-Client: true X-Google-Header-Order: ARLUEHCNK X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2),gzip(gfe) Xref: news.cambrium.nl On Nov 10, 9:27=A0pm, onedbguru wrote: > On Nov 10, 10:57=A0am, Alberto Marchi 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 > > > =A0SELECT * FROM > > =A0 LINKTOORACLE..mm510TAL.CSHDET@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?- Hide quoted text - > > - Show quoted text - 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 --