Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eToPZ-0002e9-6h for pgsql-general@arkaria.postgresql.org; Tue, 26 Dec 2017 12:32:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eToPY-0003gX-Jk for pgsql-general@arkaria.postgresql.org; Tue, 26 Dec 2017 12:32:48 +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_2) (envelope-from ) id 1eToPX-0003gA-Pb for pgsql-general@lists.postgresql.org; Tue, 26 Dec 2017 12:32:48 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eToPQ-0005jt-QI for pgsql-general@lists.postgresql.org; Tue, 26 Dec 2017 12:32:47 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id D3090219E2 for ; Tue, 26 Dec 2017 07:32:38 -0500 (EST) Received: from web2 ([10.202.2.212]) by compute6.internal (MEProxy); Tue, 26 Dec 2017 07:32:38 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=bittivirhe.fi; h=content-transfer-encoding:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; bh=GnGgdUK3/DztB8RpagoF1ohg1ohYz yWZsY0Ed35DiG0=; b=nB+mlwWkhNGnE4j2w+i6OJ04o25oOdlTd78AV/PrmIpOG rchj4mB07muPWI10DgiA8uvPuw3EPmvCuWDkUiPGGuP3Di80qqTT5hfsPdb0ztUa Esh/nz34MkfO+mMva/8FzxdDGsTLIzs53WmFqV8fK8KOAWjjA8zW1ZCASdvPS7t5 g4slgbzk2DJX6Wi1BIgGEo3DnhmDamGZo5wiIK3Pw+KhhrjomnEM08l7qCRzaJDp ByZB0nlh2U8OXbTxu6RwqdsdwnkMvSPknrvIIbH/fZLW5IZz7nzJUFOrD4vEV8bE uN008Rkw8plUKC7Z4ae7IRHImo1OJcoJSCmeTyKDg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=GnGgdU K3/DztB8RpagoF1ohg1ohYzyWZsY0Ed35DiG0=; b=bnN/jg3CRxGDs0ZUJLcYSG VSWrhjI5u86ZDhZ/F/fPSU/fjLfNq0wtPqGcgLc6pl1+yQrhqcALrLQ1/J0QdRu1 82zn7Uji54fDKrNiLr4OMTLL0xyCN6nN/ne6ArLJSMK21TNx7VF5D1hDd2taAzzK UhBBBJj8LsAoyyVbJEm7jzh4If00uBnExYqa8BhXQhiq4URM2OOj0vtXm6uk48jB ee6vO+3+ve4JnPS9asPMdRv/34kI8BWGE4teBirZygEm71EGaFRuBuovBTbcLP5r qFt90M7uRw/9uwfaGrGGzML6oepEJ0Og8SAiTaoEPYPRgm0fM7VQh3PsDv7dDEHA == X-ME-Sender: Received: by mailuser.nyi.internal (Postfix, from userid 99) id A0FFF62B9E; Tue, 26 Dec 2017 07:32:38 -0500 (EST) Message-Id: <1514291558.2940368.1216079744.27D31833@webmail.messagingengine.com> From: =?utf-8?Q?Timo=20Myyr=C3=A4?= To: pgsql-general@lists.postgresql.org MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: multipart/alternative; boundary="_----------=_151429155829403683" X-Mailer: MessagingEngine.com Webmail Interface - ajax-bb99f02b Subject: Re: Oracle to postgres migration Date: Tue, 26 Dec 2017 14:32:38 +0200 In-Reply-To: <8700DEEF-606B-47EF-8EA3-D95CE1B66EA6@gmail.com> References: <8700DEEF-606B-47EF-8EA3-D95CE1B66EA6@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --_----------=_151429155829403683 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="utf-8" On Tue, Dec 26, 2017, at 11:36, Vasilis Ventirozos wrote: > I'd start with this first : https://ora2pg.darold.net > >> On 26 Dec 2017, at 02:30, Azimuddin Mohammed >> wrote:>> >> Hello, >> Can anyone guide me through the steps for migration from oracle to >> postgres with config changes required, keeping in mind that neither I >> am a oracle DBA not postgres admin>> >> -- >> >> Regards, >> Azim >> >> >> Virus-free. www.avast.com[1] I second the ora2pg tool. Currently working on oracle to postgresql migration with it and ora2pg helps a lot.But you can't get ready recipe for migration. There's ton of stuff to consider from trivial rewriting NVL queries to use COALESCE to more bigger stuff like lack of synonyms in postgresql. All depends on your current Oracle database. Timo Links: 1. https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link --_----------=_151429155829403683 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="utf-8"
On Tue, Dec 26, 2017, at 11:36, Vasilis Ventirozos wrote:
I'd start with this first : https://ora2pg.darold.net

On 26 Dec 2017, at 02:30, Azimuddin Mohammed= <azimeiu@gmail.com> wrote:<= br>

Hello,
Can anyone guide me through the steps for migration from oracle t= o postgres with config changes required, keeping in mind that neither I am = a oracle DBA not postgres admin

--

Regards,
Azim

3D""
Virus-free. www.avast.com

I second the ora2pg tool. Currently working on oracle to postgresql mi= gration with it and ora2pg helps a lot.
But you can't get ready recipe for migration. There's ton of stuff to = consider from trivial rewriting NVL queries to use COALESCE to more bigger = stuff like lack of synonyms in postgresql. All depends on your current Orac= le database.

Timo
--_----------=_151429155829403683--