Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1eTlf6-0007Uq-08
	for pgsql-general@arkaria.postgresql.org; Tue, 26 Dec 2017 09:36:40 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1eTlf5-000706-9T
	for pgsql-general@arkaria.postgresql.org; Tue, 26 Dec 2017 09:36:39 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <v.ventirozos@gmail.com>)
	id 1eTlf4-0006zo-PF; Tue, 26 Dec 2017 09:36:39 +0000
Received: from mail-wm0-x231.google.com ([2a00:1450:400c:c09::231])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <v.ventirozos@gmail.com>)
	id 1eTlex-0000bG-PM; Tue, 26 Dec 2017 09:36:37 +0000
Received: by mail-wm0-x231.google.com with SMTP id b76so34394850wmg.1;
        Tue, 26 Dec 2017 01:36:31 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20161025;
        h=from:message-id:mime-version:subject:date:in-reply-to:cc:to
         :references;
        bh=1dmLKMSGf2LXKS/7C35rAqyYhQZVMoI68OIZZ3gkUQw=;
        b=B3rhjEp5hGfMdADstfucdjru5ybHYJLQE2s5Au/i8dN97tCFeU1+FFGmKEc+0M9Xyq
         zQAU07onimMVEsoBwWjNfZ2Sh4uUImDrLxvf/zt4tfI2UpUmjAQgbM8LaiE93FjHIFMu
         tPCxmPRYl3qL01Rz9KpWFX9IuGN7/j+UAfbqYLQHbh0DWQMNRj0bBM4r5VryokKE87DD
         7pxD3qRq0cM69mx553gPCUdIY+TKfU3UvP1wQDPa99/GBqknQA46NvtppDWaTbHzdYp9
         G1V9vmhlnCJoUJQZxsbovBvBs9dgQkFzngxnD5NaPJCcEBkqBIlHPGSBmyX0/yM4bP2p
         yRHA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:from:message-id:mime-version:subject:date
         :in-reply-to:cc:to:references;
        bh=1dmLKMSGf2LXKS/7C35rAqyYhQZVMoI68OIZZ3gkUQw=;
        b=ZIhXAlhrRs5Env/fLlwU8LKcoNUEtC6+C1RzsyxJq+r3LE+q+PUXEkQfKPCiNXY/Yk
         EYDjjSRkIFNS8DdmmzVY+oM+SyOOuJ6tojR6hfYYpJcWy+n1BKWSRjgkQ+g9uICuqtPQ
         F4Epzo2lIgtnt7gh+gXpjh3OUFpheMSqExfzyHt52VljXPovlnMBecaVCPncMdxzbotJ
         Zc3g5gXNRS5Ke7T6vmoH7JMxZqT56JsFo2ARPbxBfBFkeihifKyaac4ACxl0bARzpswB
         vYMcwjrFskfn6OrbHCSrlIyUIvTt+zoPxwJgXuRXvm/xiUmdZQZiue18P4gwoIzYAJnR
         j8qg==
X-Gm-Message-State: AKGB3mL6kBeN7fr0i6vRrbeNXW3+2SSsfHeI4LE+U+/htojcGmvy5mUu
	PWQTtxOJEGXw/j6qwUGXSJE=
X-Google-Smtp-Source: 
 ACJfBotHBdU6Xo6z7t93oN9quiuWdu6YWGk2TVLHWkYQfPIgFBTUz7n8Cq2rz9Sfms4GTBXXYPT2yg==
X-Received: by 10.28.106.16 with SMTP id f16mr11066084wmc.58.1514280988742;
        Tue, 26 Dec 2017 01:36:28 -0800 (PST)
Received: from [192.168.1.5] (athedsl-4494727.home.otenet.gr. [94.71.129.143])
        by smtp.gmail.com with ESMTPSA id
 l25sm19021894wmi.35.2017.12.26.01.36.27
        (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);
        Tue, 26 Dec 2017 01:36:28 -0800 (PST)
From: Vasilis Ventirozos <v.ventirozos@gmail.com>
Message-Id: <8700DEEF-606B-47EF-8EA3-D95CE1B66EA6@gmail.com>
Content-Type: multipart/alternative;
	boundary="Apple-Mail=_43409593-D490-44C6-9D31-E013BB92A312"
Mime-Version: 1.0 (Mac OS X Mail 11.2 \(3445.5.20\))
Subject: Re: Oracle to postgres migration
Date: Tue, 26 Dec 2017 11:36:26 +0200
In-Reply-To: 
 <CAKUuFd6Grtyof7brKu1DcfsxwDYwutUtvp_ezYSc=uRwdX15CQ@mail.gmail.com>
Cc: pgsql-general@postgresql.org,
 pgsql-sql@postgresql.org,
 pgsql-admin <pgsql-admin@postgresql.org>
To: Azimuddin Mohammed <azimeiu@gmail.com>
References: 
 <CAKUuFd6Grtyof7brKu1DcfsxwDYwutUtvp_ezYSc=uRwdX15CQ@mail.gmail.com>
X-Mailer: Apple Mail (2.3445.5.20)
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Precedence: bulk


--Apple-Mail=_43409593-D490-44C6-9D31-E013BB92A312
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii

I'd start with this first : https://ora2pg.darold.net =
<https://ora2pg.darold.net/>

> On 26 Dec 2017, at 02:30, Azimuddin Mohammed <azimeiu@gmail.com> =
wrote:
>=20
> 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
>=20
> --=20
>=20
> Regards,
> Azim
>=20
>=20
>  =
<https://www.avast.com/sig-email?utm_medium=3Demail&utm_source=3Dlink&utm_=
campaign=3Dsig-email&utm_content=3Dwebmail&utm_term=3Dicon>	=
Virus-free. www.avast.com =
<https://www.avast.com/sig-email?utm_medium=3Demail&utm_source=3Dlink&utm_=
campaign=3Dsig-email&utm_content=3Dwebmail&utm_term=3Dlink> =
<x-msg://28/#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

--Apple-Mail=_43409593-D490-44C6-9D31-E013BB92A312
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=us-ascii

<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3Dus-ascii"></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; line-break: after-white-space;" class=3D"">I'd =
start with this first :&nbsp;<a href=3D"https://ora2pg.darold.net" =
class=3D"">https://ora2pg.darold.net</a><br class=3D""><div><br =
class=3D""><blockquote type=3D"cite" class=3D""><div class=3D"">On 26 =
Dec 2017, at 02:30, Azimuddin Mohammed &lt;<a =
href=3D"mailto:azimeiu@gmail.com" class=3D"">azimeiu@gmail.com</a>&gt; =
wrote:</div><br class=3D"Apple-interchange-newline"><div class=3D""><div =
dir=3D"ltr" class=3D"">Hello,<div class=3D"">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<br clear=3D"all" class=3D""><div class=3D""><br class=3D""></div>-- =
<br class=3D""><div class=3D"gmail_signature" =
data-smartmail=3D"gmail_signature"><div dir=3D"ltr" class=3D""><br =
class=3D"">Regards,<br class=3D"">Azim<br class=3D""><br =
class=3D""></div></div>
</div></div><div id=3D"DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" =
class=3D""><br class=3D"">
<table style=3D"border-top:1px solid #d3d4de" class=3D"">
	<tbody class=3D""><tr class=3D"">
        <td style=3D"width:55px;padding-top:13px" class=3D""><a =
href=3D"https://www.avast.com/sig-email?utm_medium=3Demail&amp;utm_source=3D=
link&amp;utm_campaign=3Dsig-email&amp;utm_content=3Dwebmail&amp;utm_term=3D=
icon" target=3D"_blank" class=3D""><img =
src=3D"https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-oran=
ge-animated-no-repeat-v1.gif" alt=3D"" width=3D"46" height=3D"29" =
style=3D"width: 46px; height: 29px;" class=3D""></a></td>
		<td =
style=3D"width:470px;padding-top:12px;color:#41424e;font-size:13px;font-fa=
mily:Arial,Helvetica,sans-serif;line-height:18px" class=3D"">Virus-free. =
<a =
href=3D"https://www.avast.com/sig-email?utm_medium=3Demail&amp;utm_source=3D=
link&amp;utm_campaign=3Dsig-email&amp;utm_content=3Dwebmail&amp;utm_term=3D=
link" target=3D"_blank" style=3D"color:#4453ea" =
class=3D"">www.avast.com</a>
		</td>
	</tr>
</tbody></table><a =
href=3D"x-msg://28/#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width=3D"1" =
height=3D"1" class=3D""></a></div>
</div></blockquote></div><br class=3D""></body></html>=

--Apple-Mail=_43409593-D490-44C6-9D31-E013BB92A312--