Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Z7srD-0005v8-TI for pgsql-admin@arkaria.postgresql.org; Wed, 24 Jun 2015 22:09:24 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1Z7srD-0007AV-EF for pgsql-admin@arkaria.postgresql.org; Wed, 24 Jun 2015 22:09:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1Z7srC-0007AF-El for pgsql-admin@postgresql.org; Wed, 24 Jun 2015 22:09:22 +0000 Received: from resqmta-ch2-06v.sys.comcast.net ([2001:558:fe21:29:69:252:207:38]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Z7sr3-0000tt-Br for pgsql-admin@postgresql.org; Wed, 24 Jun 2015 22:09:21 +0000 Received: from resomta-ch2-20v.sys.comcast.net ([69.252.207.116]) by resqmta-ch2-06v.sys.comcast.net with comcast id kN841q0042XD5SV01N96bu; Wed, 24 Jun 2015 22:09:06 +0000 Received: from jerry.enova.com ([38.98.177.132]) by resomta-ch2-20v.sys.comcast.net with comcast id kN8w1q0072rmZlA01N8yAC; Wed, 24 Jun 2015 22:09:04 +0000 Received: by jerry.enova.com (Postfix, from userid 1001) id CEEBC7401EC; Wed, 24 Jun 2015 17:08:55 -0500 (CDT) From: Jerry Sievers To: "Saravanan S" Cc: Subject: Re: PostgreSQL to Oracle DBLink References: <02c301d0add5$89539560$9bfac020$@alshaya.com> Date: Wed, 24 Jun 2015 17:08:55 -0500 In-Reply-To: <02c301d0add5$89539560$9bfac020$@alshaya.com> (Saravanan S.'s message of "Tue, 23 Jun 2015 22:26:22 +0530") Message-ID: <86r3p0n4i0.fsf@jerry.enova.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=q20140121; t=1435183746; bh=TlSehwoYu7pxlJLYGrtoEDAX92h3QHKH39iLzToNur0=; h=Received:Received:Received:From:To:Subject:Date:Message-ID: MIME-Version:Content-Type; b=d/Yf+G6iTD3asmLErnL2sfTeNtNFFOSnmtP+EOiSy9Mkv0t8clJAe/RpO6ZWBTbPW EkNQ+Rui3lkwFCae9FWZVYv58G7mIMeHXYfgo+HxdkvmTbNb3e6SvCuZGPhMXV+H3S 7JmGFy0ZUqEb4R87/WjplrHO8KW1cxggIan5q7bSuEhLXOPV5NuCITxxQlE+ICSib+ /XGe04sLL7RHcvWI4lkdySn3B/Q0Oc6VJnKtKnpiBepvD3z33S9csze4/N8lpEoRwv Dhbq71+JHPxoNkEkJ1mZLXAG3QFesB7te65mSKZQGcIGIc1kkWwZEDS9uj2UI9NMR6 LeUNi0OaSFNlQ== X-Pg-Spam-Score: -2.9 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org "Saravanan S" 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