You can try http://oracle-fdw.projects.postgresql.org/
On Wed, Apr 10, 2013 at 12:07 AM, kiran <kiran.peddire...@cmegroup.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >