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?
 
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:
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
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.