CODEWITHSUNDEEP
postgresqloracle11gpostgresql-9.2dblink
kinkajou
kinkajou

Reputation: 3728

How do i create postgres to oracle dblink?

How do I create dblink in postgres 9.2 ? I want to be able to use it using @ link in oracle? I am using postgres 9.2 64bit. DBlink is from postgres 9.2 to Oracle 11g.

Upvotes: 11

Views: 48860

Answers (1)

Leo
Leo

Reputation: 1136

If you need to access postgresql FROM Oracle:

http://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/

If you need to access Oracle FROM postgresql:

http://pgxn.org/dist/oracle_fdw/

Upvotes: 21

Related Questions