How to read oracle table's data from postgre
Hello ,
I want to read oracle database table data from postgre. (like in oracle we
can use database links, is there something like this available in
postgre).
I tried below -
select dblink_connect('host=.., dbname=..user=.. pwd=..'); but it is
giving error database refused connection. Do i need to add anything in
oracle datbase server tnsnames. how should be this entry.(since here we
are connecting oracle to postgre and not the oracle to oracle)
Thanks in advance..
Regards,
Venkat
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
venkatrao.b@tcs.com wrote:
Hello ,
I want to read oracle database table data from postgre. (like in
oracle we can use database links, is there something like this
available in postgre).
I tried below -select dblink_connect('host=.., dbname=..user=.. pwd=..'); but it is
giving error database refused connection. Do i need to add anything in
oracle datbase server tnsnames. how should be this entry.(since here
we are connecting oracle to postgre and not the oracle to oracle)
postgresql's dblink functions can only connect to other postgresql
databases. it has no idea how to connect to Oracle, or any other sort
of database.
On Mon, 2010-03-08 at 10:40 +0530, venkatrao.b@tcs.com wrote:
I want to read oracle database table data from postgre. (like in
oracle we can use database links, is there something like this
available in postgre).
(It is not postgre, it is PostgreSQL or Postgres.)
You can try dbi-link:
http://pgfoundry.org/projects/dbi-link/
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
2010/3/7 Devrim GÜNDÜZ <devrim@gunduz.org>:
On Mon, 2010-03-08 at 10:40 +0530, venkatrao.b@tcs.com wrote:
I want to read oracle database table data from postgre. (like in
oracle we can use database links, is there something like this
available in postgre).(It is not postgre, it is PostgreSQL or Postgres.)
You can try dbi-link:
Anyone know if this is still active / developed?
Scott Marlowe wrote:
Anyone know if this is still active / developed?
http://wiki.postgresql.org/wiki/SqlMedConnectionManager
That's still the right long-term approach for a lot of these problems,
so while activity on it happens in bursts I don't think it will ever go
completely inactive. I expect SQL/MED plans for the next release may
get fleshed out at this year's developer's meeting in a couple of
months, should have a better idea who might be working on this by the
end of May.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us