pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PostgreSQL to Oracle DBLink
3+ messages / 2 participants
[nested] [flat]

* PostgreSQL to Oracle DBLink
@ 2015-06-23 16:56 Saravanan S <saravanan.s@alshaya.com>
  2015-06-24 22:08 ` Re: PostgreSQL to Oracle DBLink Jerry Sievers <gsievers19@comcast.net>
  0 siblings, 1 reply; 3+ messages in thread

From: Saravanan S @ 2015-06-23 16:56 UTC (permalink / raw)
  To: pgsql-admin

Hi All,

 

How to achieve DBLink from postgresql to oracle database.

 

 

 

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.

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: PostgreSQL to Oracle DBLink
  2015-06-23 16:56 PostgreSQL to Oracle DBLink Saravanan S <saravanan.s@alshaya.com>
@ 2015-06-24 22:08 ` Jerry Sievers <gsievers19@comcast.net>
  2015-06-25 09:38   ` Re: PostgreSQL to Oracle DBLink Saravanan S <saravanan.s@alshaya.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Jerry Sievers @ 2015-06-24 22:08 UTC (permalink / raw)
  To: Saravanan S <saravanan.s@alshaya.com>; +Cc: pgsql-admin

"Saravanan S" <saravanan.s@alshaya.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.consulting@comcast.net
p: 312.241.7800


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: PostgreSQL to Oracle DBLink
  2015-06-23 16:56 PostgreSQL to Oracle DBLink Saravanan S <saravanan.s@alshaya.com>
  2015-06-24 22:08 ` Re: PostgreSQL to Oracle DBLink Jerry Sievers <gsievers19@comcast.net>
@ 2015-06-25 09:38   ` Saravanan S <saravanan.s@alshaya.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Saravanan S @ 2015-06-25 09:38 UTC (permalink / raw)
  To: 'Jerry Sievers' <gsievers19@comcast.net>; +Cc: pgsql-admin


Hi Jerry,

Thanks for your support.

May I know any other possible way to achieve postgresql to oracle dblink. We
checked ora_fdw, in this we cannot access the procedures and functions also.



Thanks & Regards

Saravanan.S
DBA Officer | Alshaya India,
Block G, Gopalan Global Axis,
Whitefield, Bangalore.
OFFICE: (+91)8030435677
MOBILE: +91-8971345521
www.alshaya.com

-----Original Message-----
From: Jerry Sievers [mailto:gsievers19@comcast.net] 
Sent: 25 June 2015 03:39
To: Saravanan S
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] PostgreSQL to Oracle DBLink

"Saravanan S" <saravanan.s@alshaya.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.consulting@comcast.net
p: 312.241.7800

============================================================================================================================================
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.


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2015-06-25 09:38 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-06-23 16:56 PostgreSQL to Oracle DBLink Saravanan S <saravanan.s@alshaya.com>
2015-06-24 22:08 ` Jerry Sievers <gsievers19@comcast.net>
2015-06-25 09:38   ` Saravanan S <saravanan.s@alshaya.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox