Forum Stats

  • 3,741,756 Users
  • 2,248,473 Discussions


ODBC from Oracle to an other Database (Postgresql)

463410 Member Posts: 8

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,



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

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

    SQL> connect system
    Enter password:

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

    Database link created.

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


    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

    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 -
  • 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.


This discussion has been closed.