Forum Stats

  • 3,741,756 Users
  • 2,248,473 Discussions
  • 7,861,976 Comments

Discussions

ODBC from Oracle to an other Database (Postgresql)

463410
463410 Member Posts: 8
Hello,

I heared that it is possible with Oracle to make a "Database Link" so in Oracle I can make a query like

select * from [email protected] where ....

Is such a database link allowed with the Express Edition and how will I do this?

Thank you,

Christian

Comments

  • 241066
    241066 Member Posts: 776
    Database links to/from other Oracle databases work. As follows
    SQL*Plus: Release 10.2.0.1.0 - Beta on Mon Oct 31 11:56:42 2005

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    SQL> connect system
    Enter password:
    Connected.

    SQL> create database link remote connect to hr identified by hr using 'xe';

    Database link created.

    SQL> select count(*) from [email protected];

    COUNT(*)
    ----------
    107

    Note that this is doing a local loopback to the same database. However, you should also be able to access other Oracle databases provided you have the correct tnsnames.ora definition set up in the right directory - on my Windows system for the default XE install that is
    C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN

    Connection from Oracle Database XE to third party databases via the ODBC heterogeneous services should be possible as well, but I will need to download a 3rd party product to test it. Will do so later. In the meantime, here is a link to some doc that may help you test the setup yourself - http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14232/admin.htm#i1007209
  • 463410
    463410 Member Posts: 8
    Thank you for your answer.

    I thought it was not possible to use the "heterogeneous services" because it was written in the release notes that this feature is not supported.

    But the release notes are now gone. So I can't look at them ;-)

    I will figure it out. It would make it easier to migrate to oracle.

    Thanks,

    Christian
This discussion has been closed.