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
