Обсуждение: How to connect to an oracle table from Postgres?
Hi List; I want to be able to read an oracle tabe from within Postgres. The Oracle db is on a different server within the same network.Is there a good way to pull this off? Thanks. -joe
On 6/6/06, dba@ciberforce.net <dba@ciberforce.net> wrote: > I want to be able to read an oracle tabe from within Postgres. The Oracle db is on a different server within the same network.Is there a good way to pull this off? Your only option with native PostgreSQL is to use dbi-link. Not to explicitly plug EnterpriseDB here, but we have a native OCI-based connector for PostgreSQL which is quite a bit faster than dbi-link if speed is what you need. dbi-link: http://pgfoundry.org/projects/dbi-link/ EnterpriseDB Release 2 Beta 3: http://www.enterprisedb.com/products/download.do -- Jonah H. Harris, Software Architect | phone: 732.331.1300 EnterpriseDB Corporation | fax: 732.331.1301 33 Wood Ave S, 2nd Floor | jharris@enterprisedb.com Iselin, New Jersey 08830 | http://www.enterprisedb.com/
On Tue, Jun 06, 2006 at 11:13:48AM -0400, dba@ciberforce.net wrote: > > Hi List; > > I want to be able to read an oracle tabe from within Postgres. The Oracle db is on a different server within the same network.Is there a good way to pull this off? Only way to do it from within PostgreSQL would be to write a function in a language that can connect to Oracle, such as plperl. There's been talk about extending dblink to support connecting to other databases, but I don't think anything has actually happenend on that front. If solutions outside the database are acceptable then you have more choices, though most of them are commercial. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461