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: 4502
Registered: April 1998
Senior Member
You should be able to, just create a view or synonym on B.
Previous Topic: Problem in connecting Sql server2000 from Oracle10g using oracle gateway (using Db links)
Next Topic: INSTANCE BLOCKED
Goto Forum:
  


Current Time: Wed Dec 07 04:59:28 CST 2016

Total time taken to generate the page: 0.05296 seconds