Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jS2na-00024u-Ik for pgsql-admin@arkaria.postgresql.org; Fri, 24 Apr 2020 18:11:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jS2nY-0004zl-1u for pgsql-admin@arkaria.postgresql.org; Fri, 24 Apr 2020 18:11:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jS2nX-0004ze-Gm for pgsql-admin@lists.postgresql.org; Fri, 24 Apr 2020 18:11:35 +0000 Received: from sonic316-11.consmr.mail.bf2.yahoo.com ([74.6.130.121]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jS2nP-0000rL-Mo for pgsql-admin@lists.postgresql.org; Fri, 24 Apr 2020 18:11:33 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1587751885; bh=m0Wc2iPJRpWFxlXQ87WpJ8ZeTd1KO+YKZD9duTmG4cY=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=qCTjCq+rdVXSJEIFMWwXs8ISAB5Br4Ju1TfmdF+m/fIJqLfrMdVBY/ZFSPYYhBNY3dm2HbLRrmtBm4sRaSahNSe6Cvcn4fWWHXrIdE6/TUnBnX7HYaGKWbi+fb1IZPexNU4xs8TXeEHp/v/PcqSvEsIH/o/HOLLj6k05HIX9dLsCkldTMbSoQ4bbBkuINxT+LAbJJoOYFoonSPY/XpccWEdvXZadWbDi+rJfqwVaCRtzRWze7UXlcE4TsRK77FjsXs72ybpYDWdcnA+JeSNrAttKd5g0f+x2hBZhUDAvgqCmMvFWrKU0VEGRDi/iAVNIjXbZmdB5+UEu3CikXvxTfw== X-YMail-OSG: kKOU_qoVM1menXZ8HDcFi3.KDHAgv.DRfsPV3r6R.Q3I3bSOn6vr.8uH3hfn7F9 KBnf4Oc.p9Df1OrN7fBXCaFWVNLz9GKOU1Dt7YOqdjFYTSl.f_N9l09yTpsDkbrBlr._UIcwJ6JL lek6J_rUDtvqVeFEdjKn.0cJoQW8s.s4bG_hhrcyXnXHiGakO5cisyd1jhIoZFxCecSjZo._AH89 aUiHTAQJJPrTTMWGMUkrLU5kN0zZi.KpU9fe7w7Esgb4TUiVG5ZvzqwbcO1ZbUr8xNcjfDsOj95w WlNUl2Yo.xeNoy6EarR0FNn0_yrb7SGuGU_NrSG1MrG8bQSYNisPnTc7OC.m_op3YsjqFvNX_neI mbsJ5WzUIHDdF6qA_uS60fxirDw11EBCzSg.UF7yGQAREDsNd6YZHl8qlwq6Zql3zMPFEI7OCESL vR5h261A7StzeXthiDKCMWgJB65n5oyPHBF9lRXG5I5dTbaYh__eAdTmGNvOM.s2Wzu3wbijqtzS 9zDt1X4ez5eijFvrrO3Pif5.HUU1hSuwWiA0.QKuqZX8x_RQfKZHWMj64q_EXEXCpRjJ8oNHUu7R MHkJQJSCS0t374nbxv9cvRJu_0hLTI8k8OVALvJ5oqdndMB9y_q8isf8VwjFF25BBf7TBWW7er.A YVVCo46vNRyVCWEMNKFh0rYlbxsnGBxCviCPgcjQl3W5M6n_ju4h.QIN6aBvkqKNtA9kHLRgs4JE 5sGJOZx12TfZsFj.13kqf6YOlDM.GBTm02LMgxnzCP0ZujfO7kL1cbaEhKz2hplXhXiS3S0VOQtz hQ.qpHQDjLJW1d.euAw6MQIoguTOFthE7WuJEIbCyUnPD.3d4hH1nMD7uhrJXxIM4RF2rrN8s8oy gW.igmnxY74W_Z1UW5IYBmsKMKt9HkUYGL9qMZDUWfvIcAhqFVxwaG8UM3QaHvLmu8fgvAVOrIBK hpQ8OLwIJQ5xnXz58M_ZFuH68SrPPr8UoGsJhNlQLK84exwfR5erMFr4rNjCUCrWLAv2i.4r4uui vV2vbWwHNiGK0E5_J1PArx39TitaS4LM9jJh8qnCpUOowNzjov0Y9tqfXM1thXEa4TLUS0D4_QnO KxwegQziVat88aNLkMvYzsltfFvICX1YbZiPTqX26gVgpP4LQqYv1.DdMVCw6Oo0u5DDYA7CxrTL E5uRkROmcD182lfBkm5RtkeIjoCDdVtGiNLk7m0uZ6I27.luIg3MpX5Ub4bWhi0pGLqkpSNTEMKS MQek7rHHynkCmsoEOXXz5FmWb8uPkSI0cyiooXkbW9cgxDRhaoqFNlMJuJKOkyOx6eqcYWEgubJE 5pAu0O77izQIiMhugkdbVQQgX1zWLIreWBAJ8ySY- Received: from sonic.gate.mail.ne1.yahoo.com by sonic316.consmr.mail.bf2.yahoo.com with HTTP; Fri, 24 Apr 2020 18:11:25 +0000 Date: Fri, 24 Apr 2020 18:11:21 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: "Jonah H. Harris" Cc: pgsql-admin@lists.postgresql.org, Thomas Kellerer Message-ID: <956690593.227606.1587751881305@mail.yahoo.com> In-Reply-To: References: <172687860.2288957.1587391373846@mail.yahoo.com> Subject: Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_227605_1867043661.1587751881303" X-Mailer: WebService/1.1.15776 YMailNorrin Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.113 Safari/537.36 Content-Length: 6256 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_227605_1867043661.1587751881303 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable oracle version 12.1 in linux 5.6 - productionand in lab aws, oracle 12.1 as= well. Gov needs to see how can we migrate or not before approve to use postgres a= nd move all out off oracle. thank you Bach-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 Friday, April 24, 2020, 12:57:29 PM EDT, Jonah H. Harris wrote: =20 =20 On Mon, Apr 20, 2020 at 10:03 AM Pepe TD Vo wrote: Can we use an oracle dump file? While I generally think the FDW copy is the best (and fastest) approach, I = have a tool that can import Oracle export files into Postgres. What version= of Oracle? --=20 Jonah H. Harris =20 ------=_Part_227605_1867043661.1587751881303 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
oracle version 12.1 in linux 5.6 = - production
and in lab aws, or= acle 12.1 as well.

Gov needs to see how can w= e migrate or not before approve to use postgres and move all out off oracle= .
tha= nk you

<= font color=3D"#8000ff">Bach-Nga

No one in this world is = pure and perfect.  If you avoid people for their 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 appear= ances. But to those who knew him well, he was a perfect gentleman (Hermione= Gingold)

= **Live simply **Love generously **Care deeply **Speak kindly.
<= div id=3D"ydpc4982ab8yui_3_13_0_rc_1_1_1381789421038_7866" class=3D"ydpc498= 2ab8yiv3811552299ms__id13894">*** Genuinely rich *** Faithful talent *** Sharing succe= ss


=20
=20
On Friday, April 24, 2020, 12:57:29 PM EDT, Jonah H. Ha= rris <jonah.harris@gmail.com> wrote:


On Mon, Apr 20, 2020 at 10:03 AM Pepe TD Vo <pepevo@yahoo.com> wrote:
Can we use an oracle dump file?


While I generally th= ink the FDW copy is the best (and fastest) approach, I have a tool that can= import Oracle export files into Postgres. What version of Oracle?

--
Jonah H. Harris

------=_Part_227605_1867043661.1587751881303--