Solved

database_link

Posted on 2006-11-11
8
237 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 

Author Comment

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

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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 143

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
 

Author Comment

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

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

730 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