ODBC from Oracle to an other Database (Postgresql)

463410

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

241066

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

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