Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

database_link

i know database link is very important? datalink is used to access object of another database..right and is it possible to access from non-oracle database? can u give me an example to create database link in between oracle and between oracle and non-oracle database?
0
dbaseek
Asked:
dbaseek
  • 4
  • 3
1 Solution
 
dbaseekAuthor Commented:
can u help me??
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
yes, using Oracle Transparent Gateways:
http://www.oracle.com/technology/documentation/gateways.html

never did it yet myself, however
0
 
dbaseekAuthor Commented:
it is more confusing and could u help me with something else...
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>right and is it possible to access from non-oracle database?
yes, using transparent gateways. however, not all non-oracle databases can be accessed like that, and for each product you will need to install and configure it's own transparent gateway.
hence, the lot of documentation that you found in the link above.

>an u give me an example to create database link in between oracle and between oracle and non-oracle database?
as I never did it myself, and especially as you did not specify which other database, it will not be possible for me.
0
 
dbaseekAuthor Commented:
can u provide me some syntaxes??
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
If you don't read what I (or someone else) write, it will be difficult to learn!
let me repeat:
::as I never did it myself, and especially as you did not specify which other database, it will not be possible for me.
0
 
rbrookerCommented:
Hi,

yes it is possible, my collegue and i have set up something like this that queries interbase tables from an oracle database.

http://www.experts-exchange.com/Databases/Oracle/Q_22053031.html

good luck. :)
0
 
dbaseekAuthor Commented:
thanks
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now