On 16 November 2010 20:09, Hu, William <HuW@trimet.org> wrote:
> Hi, I have a need to select some data in a Oracle database from a Postgresql
> table. I know how to do this among Oracle instances, eg. Select * from
> table@another_instance.
>
>
>
> Are there similar approach without replicate the database tables?
>
>
>
> Thanks in advance.
Yes. Look at dbi-link.
--
Regards,
Peter Geoghegan