Re: Create a DBLink from PostrgeSQL 9.2 to Oracle 11g

You can try http://oracle-fdw.projects.postgresql.org/

On Wed, Apr 10, 2013 at 12:07 AM, kiran <kiran(dot)peddireddy(at)cmegroup(dot)com>wrote:

> 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.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>