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