Create a DBLink from PostrgeSQL 9.2 to Oracle 11g

From: kiran <kiran(dot)peddireddy(at)cmegroup(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Create a DBLink from PostrgeSQL 9.2 to Oracle 11g
Date: 2013-04-09 16:07:43
Message-ID: 1365523663919-5751446.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I am looking for an example on creating a DBLink from PostrgeSQL 9.2 to
Oracle 11g.
I tried the below link and for some reason the ODBC_Link installation is
failing.

FYI.,
http://vibhork.blogspot.com/2011/05/postgresql-database-link-to-oracle.html

I have the Heterogeneous DB Connection Between Oracle And PostgreSQL. I want
the other way, reason being, I have 100's of oracle database and I need to
pull data from these oracle databases and store into PostgreSQL.

I tried many thing and not successful on the creating a DBLink from
PostrgeSQL 9.2 to Oracle 11g.

Any help, highly appreciated.
Waiting for your response.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Create-a-DBLink-from-PostrgeSQL-9-2-to-Oracle-11g-tp5751446.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2013-04-09 16:13:18 Re: Disallow SET command in a postgresql server
Previous Message Alvaro Herrera 2013-04-09 16:06:59 Re: Disallow SET command in a postgresql server