Home » RDBMS Server » Networking and Gateways » How to select data throw two dblinks ?
How to select data throw two dblinks ? [message #196235] Wed, 04 October 2006 10:28 Go to next message
**Snake**
Messages: 47
Registered: December 2005
Location: Italy
Member
I have three databases:
- database A with a link to database B : DblinkAB
- database B with a link to database C : DblinkBC
- database C with a table : MyTable

Is it possible to select MyTable information from database A? What is the select.... syntax?

[Updated on: Wed, 04 October 2006 10:28]

Report message to a moderator

Re: How to select data throw two dblinks ? [message #196326 is a reply to message #196235] Thu, 05 October 2006 00:46 Go to previous message
Frank Naude
Messages: 4596
Registered: April 1998
Senior Member
You should be able to, just create a view or synonym on B.

Report message to a moderator

Previous Topic: Problem in connecting Sql server2000 from Oracle10g using oracle gateway (using Db links)
Next Topic: INSTANCE BLOCKED
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Oct 04 00:16:19 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.