Solved

database_link

Posted on 2006-11-11
8
235 Views
Last Modified: 2012-05-05
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
Comment
Question by:dbaseek
  • 4
  • 3
8 Comments
 

Author Comment

by:dbaseek
ID: 17920573
can u help me??
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17920575
yes, using Oracle Transparent Gateways:
http://www.oracle.com/technology/documentation/gateways.html

never did it yet myself, however
0
 

Author Comment

by:dbaseek
ID: 17920629
it is more confusing and could u help me with something else...
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17920884
>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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:dbaseek
ID: 17923400
can u provide me some syntaxes??
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17924537
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
 
LVL 18

Accepted Solution

by:
rbrooker earned 500 total points
ID: 17926644
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
 

Author Comment

by:dbaseek
ID: 17927820
thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now