Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gkAwc-0004n3-G3 for pgsql-admin@arkaria.postgresql.org; Thu, 17 Jan 2019 16:55:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gkAwb-0003FW-7O for pgsql-admin@arkaria.postgresql.org; Thu, 17 Jan 2019 16:55:05 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gkAwa-0003FO-SV for pgsql-admin@lists.postgresql.org; Thu, 17 Jan 2019 16:55:05 +0000 Received: from sonic301-4.consmr.mail.bf2.yahoo.com ([74.6.129.43]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gkAwX-0003Bd-SG for pgsql-admin@lists.postgresql.org; Thu, 17 Jan 2019 16:55:03 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1547744101; bh=2oT7uERdESoQ1pwDr78nN87xzOy2pqfnNzaBNePl3xk=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=nhih/H72vzcaWr1wBxpd4e/SLpFotIgoSP98qE/D5tbRKMi8SWZmme57aB8t5E8OEZpy03PfUtZCw4wDQ9T+PsHG9Zkjhd/Bs/3K3obaVx0qdijz69aLkYbgX8KzQmLaAnkMvg0ex59BQTO4WNlbnCsHqMBb6qVTEKrt5gtucysiL5SLz8kQdg2hSQWrADtIpmbrmIo1RkfoNVMdTZmgPNUJ6ATnGsRY8HbBTlid/yab6Jb3guqae5mbWORT50FM/bXBCEfidEE8khBxtkOUWnbxFstyGsWUP5izrzRdajKkjbQLeZBY+Wdr6igjlZxaDWpmuGR4OhXwyiHqpjYsBQ== X-YMail-OSG: gEm6yf0VM1lzCkUSvlP2uYrOf32MAtztmnujTlAKh6sAMT3GiawKAz3sAs82.9d lyONDuWjbtn0bOCsEDX8nEFA1L70pJVT4ydW96uWq.iNkPf9NpmiIKd3JpZGzpzfK8w7xd5RQiyr VkF13VXMP8.yaPFeSyHDDuCogNmcMAJWfrr9w4V7CrkPw9VdYMSBPCB.oE6c.o3WsOQzcE9mbWkZ twQfBreBntjqqtR23QxoqwO_jsNQQDPHmIk4QgMx34ZygiBqhMHOJweaz4aimrcMK60rAc.K.pRm 5N6QpyeO6ZatMeD1OLge5mHfzn4SLFGI.R5DQovpQObB2XY.4bQ48gdE4In0luW9J.VIrram_Ahw MEIhVtglQ2Udh8l7EHzx_urROYGxoSvADj209V1A1qViUtyIOCi.dva9YgKvzZN_iCk59B4WDRS. 0xtQ7dodjfMSZyJ3hfkrh9LDY4T4yZSRtYchR.ND1a2tysI2yaDnsL1J_J9qPBsfhD1aGYbaeK4G 0Zq58_JKumRhKvMjsa93Qe8C01B_hyYx4TMwurFR2YS53zINWWoE_SeKwicfvkQwb_afGTk.IMEc SFJ_iV5RWDb2eI.XVFzXjVIUtl8tcBzDcN9QTXzFLgVI48TtKEfe7B1U0iatE5l9oxcPw1M7pk21 P4gdJ6cRV1TVlbDmjuxBBQLJWmUxatmeGWvTji62zaWYZ_6yEomcw00BH4gkAkdJeERXF.os6S3K W2ezxyCa4BCCxnPIkgQ1_MQTEBsk6qNxkuzHIv9Tr1g0x5ntPM6mKBKvlCzRmUX0sOVM_tZhl6ol .4vSCn7codEMY1W3bhhTkH8bMIotkvfVztZlgHtTYsfISDWEpHG_iO_vR2tPaBsiglHXqqOfT9Bz j.BMbyTop5oVtfjqXdg8rStQop4zCnuYaSQM3NhuIpCbIU.T68vkBg07_Ya5yTmuZzwj6SxEJ.rK AwR1WC7nlXKzqO6B306t8UBhbTdPo2TihbBTUT6LaTdk4ydUukjmUc2qvvB6qIt4sORPHMzFEfax MAQj7Frkesy72ygbzl9lFIegH6uxdzlULxwO55vc_pVZigFJY5POZxZvl1DmgusxJ7TZKRlMjbg- - Received: from sonic.gate.mail.ne1.yahoo.com by sonic301.consmr.mail.bf2.yahoo.com with HTTP; Thu, 17 Jan 2019 16:55:01 +0000 Date: Thu, 17 Jan 2019 16:54:54 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: "David G. Johnston" Cc: marcelo zen , Shreeyansh Dba , Pgsql-admin Message-ID: <74388008.1250118.1547744094605@mail.yahoo.com> In-Reply-To: References: <13812124.1254768.1547742281100.ref@mail.yahoo.com> <13812124.1254768.1547742281100@mail.yahoo.com> Subject: Re: Copying Data from Oracle to PostgreSQL MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1250117_1821907516.1547744094603" X-Mailer: WebService/1.1.12857 YahooMailNeo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36 Content-Length: 6100 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1250117_1821907516.1547744094603 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable this is not production server.=C2=A0 We need to test out on development ser= vers before playing with a real one.=C2=A0Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir mistakes you will be alone. So judge less, love and forgive more.To call= him a dog hardly seems to do him justice though in as much as he had four = legs, a tail, and barked, I admit he was, to all outward appearances. But t= o those who knew him well, he was a perfect gentleman (Hermione Gingold) **Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely = rich *** Faithful talent *** Sharing success=20 On Thursday, January 17, 2019 11:52 AM, David G. Johnston wrote: =20 On Thu, Jan 17, 2019 at 9:24 AM Pepe TD Vo wrote: > I don't have a 3rd server to install ora2pg to connect between two oracle= and postgres db servers.=C2=A0 Contract is not funded to get extra server(= s) and/or training. Assuming the existing Oracle server is in production I would recommend you not install stuff there which only leaves the new PostgreSQL server as an option given your apparent limitations. That's likely that last I will say on the topic - I agree with Laurenz's sentiments; You don't seem to be in a position to personally fulfill this contract that you've been assigned and you need to consider how to deal with that fact.=C2=A0 You haven't even gotten to the hard part yet and your hands are tied in ways they should not be (i.e., the machine you are performing the work on, a newly created virtual machine workstation ideally, should have internet access). David J. =20 ------=_Part_1250117_1821907516.1547744094603 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
= this is not production server.  We need to test out on developme= nt servers before playing with a real one.
&nbs= p;
=
Ba= ch-Nga

No one in this world is pur= e and perfect.  If you avoid people for their mistakes you will be alo= ne. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much a= s he had four legs, a tail, and barked, I admit he was, to all outward appe= arances. But to those who knew him well, he was a perfect gentleman (Hermio= ne Gingold)

**Live si= mply **Love generously **Care deeply **Speak kindly.
<= span id=3D"yui_3_13_0_rc_1_1_1381789421038_7865" class=3D"yiv3811552299sg">= *** Gen= uinely rich *** Faithful talent *** Sharing success


=
On Thursday, January 17,= 2019 11:52 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:=


On Thu, Jan 17, 2019 at 9:24 AM Pepe TD Vo <pepevo@yahoo.= com> wrote:

> I don't have a 3rd server to install ora2pg to connect betwe= en two oracle and postgres db servers.  Contract is not funded to get = extra server(s) and/or training.


Assuming the existing Oracle server is in production I would recommend
you not install stuff there which only leaves the new Postgr= eSQL
server as an option given your apparent limitations.=

That's likely that last I will say on= the topic - I agree with
Laurenz's sentiments; You don't= seem to be in a position to personally
fulfill this cont= ract that you've been assigned and you need to
consider h= ow to deal with that fact.  You haven't even gotten to the
hard part yet and your hands are tied in ways they should not be
(i.e., the machine you are performing the work on, a newly c= reated
virtual machine workstation ideally, should have i= nternet access).

David J.



------=_Part_1250117_1821907516.1547744094603--