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.
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.