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?
dbaseekAsked:
Who is Participating?
 
rbrookerConnect With a Mentor Commented:
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:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
dbaseekAuthor Commented:
it is more confusing and could u help me with something else...
0
 
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
 
dbaseekAuthor Commented:
thanks
0
All Courses

From novice to tech pro — start learning today.