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 1jJHfq-0006Dw-0Q for pgsql-general@arkaria.postgresql.org; Tue, 31 Mar 2020 14:15:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jJHfo-0001dw-Tw for pgsql-general@arkaria.postgresql.org; Tue, 31 Mar 2020 14:15:24 +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 1jJHfo-0001dh-AQ for pgsql-general@lists.postgresql.org; Tue, 31 Mar 2020 14:15:24 +0000 Received: from sonic310-14.consmr.mail.bf2.yahoo.com ([74.6.135.124]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jJHfl-0001ac-RA for pgsql-general@postgresql.org; Tue, 31 Mar 2020 14:15:23 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1585664120; bh=tq/OyetzEUtR3Snl3p6yag401A8qlmDpbK+f7KBCiSo=; h=Date:From:Reply-To:To:Subject:References:From:Subject; b=nPQArorFzDf49nmoV4pUaCMlav/k7naMk68MxoK1XQElWKk0asbPaFbtAehdgi1vXT+HXKaZTP+AOIWT6Z732Ai/lK9quuGkArHdKrFWOEo1sJU2IJ0C2URKHBwuBDRKBTMKMWP21hx//22GFiaJD0N8o4V/mmTfjwXhjzfSpM2oZKH5lMkaa0lQNFH2UviM2ytv918CuXVIksAW6BZkq++zm29A16VyD3KS1WhZHYeaCIeOXkiG+Ud4EVmRGINLVClgoiU9QuolTvx8RmBHljcQo858V1lFtFncz+fyJh7gQ4V1E4z6FgIeSjFVouuHNX/39C6e95JpMU670Yzyzg== X-YMail-OSG: dX47.nUVM1nJwBbiBnsjtosSzqaPCBuPb2442AhGInouI.bemtsNcHTj8RQFnAd I4QL6dAd1BHSjPVpE5hOlK77aWtEpvOJQQxnYpLi7L0E.JYjWE53vYtE_wyHYcnWECT.99PIdtnv NhmFsphGgXlrZ6p3dKx74Tg0OjLHPBpCtNN0AbLGcg7zKNndY4xzubH96LNw6ynn3C2lJo1IpSQX l_sGBNYDG5X6Cy30tSo5xYqOy6PMCi1EOBDFaqvUPFekdbRojnVsjei9PTwqS1TphEgxRfnIWCjo 31L3WfIiDxVA_v2Z8aD2uWjHpQBx081qcIylZfJPY_11_kTFvboOY5n6Y9IuLxXn3Stx0BPj.Yk4 mfPRGIKuXfws6_muuCPwVKKSzUoseUGqb4U8AbM88I3NdBCsDtQZO2AcnoHqa78zMH563YGmb_rx JZrBwbPj7T3pzZhduPVar0oTXzxopWDxpjiH1Xb3pSJLgsnsPu4Pj3yakBQJTcJCZUTpaStVccVE KnD2jjfUtZA2_mAzlJ9LqdjkV8iPAjicptZjnYJUv4smaVlr0X10YaSXsw24UpGkVzO2Wzi2Xfag USO77IghnrAiBU1RUP.StPHYlRTqFFICXVc8hLdPStdBDy1dk64XfDonKqGx.yaIV0F371jzJgfT mDfyMKfRXG2PcV2m.gQ4Z7F2eMfkH7j9Ua4N4QVlPo3DfZJdbmQSaFI5WC6DHmfiASQIbDJjpvfn jBwuNHDTUTgc4O3ihVQrXsPlMIgYKIzJQTEHa_4w12PUD7gbVMfPFHiBS3JKEsRNIfkLj5uMgzPh IlLeKFjYPA4MizZXXUch6ce6hLphOXNQW4Xqa2WuBxinJAHdINTyUpwqMuT.X7AVMM62I2sG1n1l nwG5Me8I7aGXmq5.c4K6B0IsJAgsBAJl.EngcN1_Ce7yGmmn876CzNdMbaENPk3XBvEyqzHmFJVF py4rh1zxEfK7WRT8Zd7Tiq1oJG5h2diuXgnuR3ELH6.Z7tsHwaW0Ml3pwFnIYoc1S6j0p9ZTXlXE 5klUlK.ldEK3ksQzP5XegkdCA739cQGO3P.TrfjXepU3FZby04HlRTGnqT.gAaEk2CFhWlhmHBWz WzYxl0V1KsDOX0hRXyZZkgK5K5XSJnKWJT.bupSdwFFNJ.K3dLUDVkxnYGTMaBhBEvQ.HctgeOZt RcX1pr7R8SVMpEkF98FeiDFJkWW9xfWBNz7woMsTpxPmcZ9BRGDHvA5sqjsKGPZ6tPQR9C7W6RKF htrPKr6ZknhFLRVL6haPbq2BYvsbKD52UmwVC7dur_NxrxYLa6anppwn6sJIzELrW2_EAuYpFgt5 kFjCoDfB.VGaVGGRRcn.2JdaHdYaKrfMOZnM- Received: from sonic.gate.mail.ne1.yahoo.com by sonic310.consmr.mail.bf2.yahoo.com with HTTP; Tue, 31 Mar 2020 14:15:20 +0000 Date: Tue, 31 Mar 2020 14:15:19 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Pgsql-admin , Pgsql-general , PgAdmin Support List Message-ID: <1587437647.1103378.1585664119295@mail.yahoo.com> Subject: migrate off oracle data to postgres MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1103377_391141106.1585664119294" References: <1587437647.1103378.1585664119295.ref@mail.yahoo.com> X-Mailer: WebService/1.1.15555 YMailNorrin Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.149 Safari/537.36 Content-Length: 3868 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1103377_391141106.1585664119294 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello, I have a huge data on Oracle, would you please suggest how to migrate all d= ata off Oracle to Postgres?=C2=A0 Do I need to export into csv and upload t= o postgres?=C2=A0 Ora2pg is limited data from oracle to postgresql right? 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 ------=_Part_1103377_391141106.1585664119294 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello,

I have a h= uge data on Oracle, would you please suggest how to migrate all data off Or= acle to Postgres?  Do I need to export into csv and upload to po= stgres?  Ora2pg is limited data from oracle to postgresql right?=

=

Bach-= Nga

No one in this world is pure a= nd perfect.  If you avoid people for their mistakes you will be alone.= So judge less, love and forgive more.
T= o 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 to those who knew him well, he was a perfect gentleman (Hermione Gingo= ld)

**Live= simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success
------=_Part_1103377_391141106.1585664119294--