Re: PostgreSQL to Oracle DBLink

"Saravanan S" <saravanan(dot)s(at)alshaya(dot)com> writes:

> Hi All,
>
> How to achieve DBLink from postgresql to oracle database.

Consider FDW unless you are running a very old Pg version...

http://laurenz.github.io/oracle_fdw/

> Thanks & Regards
>
> Saravanan.S
>
> DBA Officer | Alshaya India,
>
> Block G, Gopalan Global Axis,
>
> Whitefield, Bangalore.
>
> OFFICE: (+91)8030435677
>
> MOBILE: +91-8971345521
>
> www.alshaya.com
>
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> Alshaya Confidentiality Notice & Disclaimer
> This email and any attached or transmitted files may contain confidential and/or privileged information and are intended solely for the addressee(s) named. If you have
> received this information in error, please notify the sender by return email, do not redistribute this email message, delete it immediately and keep no copies of it.
> All opinions expressed in this email are solely those of the author and do not necessarily represent those of Alshaya. Neither this email nor any attached or
> transmitted files constitute a binding commitment on behalf of Alshaya. Any purported commitment or purchase order is subject to final approval in accordance with our
> internal procedures and subject to contract in accordance with the relevant laws. References to Alshaya include M.H. Alshaya Co. W.L.L. and all its affiliated
> companies.
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres(dot)consulting(at)comcast(dot)net
p: 312.241.7800