Re: How to read oracle table's data from postgre

venkatrao(dot)b(at)tcs(dot)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.