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 1jJJRs-0002D7-EV for pgsql-general@arkaria.postgresql.org; Tue, 31 Mar 2020 16:09:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jJJRr-0005uI-Ct for pgsql-general@arkaria.postgresql.org; Tue, 31 Mar 2020 16:09:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jJJRr-0005u9-5L for pgsql-general@lists.postgresql.org; Tue, 31 Mar 2020 16:09:07 +0000 Received: from sonic309-21.consmr.mail.ne1.yahoo.com ([66.163.184.147]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jJJRo-0003zK-Am for pgsql-general@postgresql.org; Tue, 31 Mar 2020 16:09:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1585670941; bh=kvQ3fG/Tw79ubjhmiYgI8iJHw95WnUQgXh/It7VDY08=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=O3DmEhVqbvmka0ViTshU4eAJI2bO6l5SxQmb5TXk3uogJLLlgK7ryKeD1tukNWv3mdfvJXsrnn2A0E588imr/lj8o8cBQRkKYZLtsEexnPiYEfmZ07FAVzSSofgkoPcTCTrClxcfQxb6+ILq2BqIrRSDtJ8PE2eqFrQCFUNcw/KmeKzJ8k7hi27IaNjBAFtBfsoL0IihOy3XZfmsQsJ0zs+n8ffRD2XyK/yeXkpq6IrWLGSj7dJ4PeowQq9VXjxFX3xmM9FgVySaTc+tEHcwhM4NsHA8SdYW3WvbL3kPMIV8y7wBhdxlZUPd94MzMeaKRXFHh9bMmLF5n89c0yLHPg== X-YMail-OSG: 3n3t748VM1nwtBz3G4VVSgD5f3_1jPd3hE1J0oVElZwyYAye12k6UhgiQy_tLEu .zzR_fjaAlBszyf7UsJTbwDwjOyH_JflWys6ncnTGvkh13ZciQV5uIKUziOtPhovqStNX9n5_fgS qkuU.Xpx3zyMmy34fCWg.4TxDd_4s9w7_bfeShX3f7EuGPQxzesG6YiXKBm7.bzbGgDuv6_bqZ9Q MkTByejAociI3NrzjhyxYdoaAceVNSFDZ35YXTuY0.S.Yp_IRs54_C2RYcBSsTctiyqueiJ7G0Cf 8N7XNNCartmwCayAvKGslYEzoYO66lCd4Rr0Fwrj5T_qBKJ624wkjw9nYabs7CkrWBSphxkkyqko lLteq8nB7D5.Y_ks9uG2i2GwT7viohuIA2NW.jP0Ze_8oCOU1DwDCwfF0z.7QKg9DfFRpGK9Sfwe UUl0nAeNvtvE_IIW10Icms_Qx3JMDJlHJ3N2Ry0usx.85gcrul9xsOy7XdZHuNHUDx7aisc3ZsI1 s1zBHjyc15Zy0IfHVycI3thiyv6aeUW21TwY9Ew3E.4FomPiXlOQ32A_Zx.1jcWB6_Sk2.e85jIH 75tNSI5.Kv5xKj4HQMH51rIIir_K__Or18h5LWBdP.6NvTHPXv5QZImrMyqLwmYAXxIYZ5MPkmKd QQ111ivzBKnH4lmpdAOWUABXjQjuNuhzcgaqo4c1Rn3CWZLPFP0uyIE.TwktBxHIySKwz6rr1uCv j7ULuIuJm54PNb3a45jCqE99W8jZjF5pXhDXr4MZIp6aywP2f__OczCnskQv21PWF3uee41RMLrA VHWTSNYNxXm49G8ocn3eK4oBeUIHPVK1CjvjVVroDBEZf8UDqMr4r1UP.FWjUbHNaMGz24vALVJP FWqkKqmnjbWR._CfnPZ6B6AK0DejM6zVHgnLhFaqDVL7daiFBDmW4e39CDXRzjI.ThEALKqj9pkD k_dLAwXLg.xTm.fXihMHGdRU8S2PqSasxVE_E0CWmNkdcQT27WVe6ZQfnPOxDdmG2xsc1AoVsKCQ WJVW0MiqGi2A4fMuo0HttgM_upLB7QcfWpy_luKKopAYTW6tg3RQGvo1EjK5dc9gZ88SHcJ2wkPs hXLPIPsrrka6No7MsBYO.QgIhUBa3Yyy.oDbTz8zoSnlLMEvm5_J8AQBO4o3oR79bOA.jakz5DH9 V_kETaBkMzagRFP9TWKxTTGkZfh9Vjo1WIUzAL_3EvncNcujUvMkaVsa88ibatOEUSQH0y_xWaHD f1O2FaYdsodOEdbEKP2xwk2_ZrqCcyB.VS4fRoBLKnuzFZMZfZqQtqjsx.xsIO6TAFXDEYE6QQCF S2bIgHFzk40D8P6J1Fxeiwq0AN92lyT6tS_YyOGM- Received: from sonic.gate.mail.ne1.yahoo.com by sonic309.consmr.mail.ne1.yahoo.com with HTTP; Tue, 31 Mar 2020 16:09:01 +0000 Date: Tue, 31 Mar 2020 16:08:55 +0000 (UTC) From: Virendra Kumar Reply-To: Virendra Kumar To: Pepe TD Vo , Pgsql-admin , Pgsql-general , PgAdmin Support List , JC JC , Adrian Klaver Message-ID: <380953143.257193.1585670935977@mail.yahoo.com> In-Reply-To: References: <1587437647.1103378.1585664119295.ref@mail.yahoo.com> <1587437647.1103378.1585664119295@mail.yahoo.com> <1493124385.1141236.1585669895986@mail.yahoo.com> Subject: Re: migrate off oracle data to postgres MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_257192_1224794649.1585670935975" X-Mailer: WebService/1.1.15585 YMailNorrin Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:68.0) Gecko/20100101 Firefox/68.0 Content-Length: 3209 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_257192_1224794649.1585670935975 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable FDW for oracle and ora2pg both are too slow compared to offload data in a f= ile and load into PostgreSQL. When I was doing one of my migrations I found= the best solution was to download data using sqlldr on to the database hos= t where PostgreSQL instance is running and load it using COPY command. Regards, Virendra Kumar On Tuesday, March 31, 2020, 8:55:17 AM PDT, Adrian Klaver wrote: =20 =20 On 3/31/20 8:51 AM, Pepe TD Vo wrote: > I have tables ddl data definitions already.=C2=A0 Only need to move the d= ata=20 > over off Oracle to Postgres PostgreSQL Foreign Data Wrapper for Oracle: http://laurenz.github.io/oracle_fdw/ --=20 Adrian Klaver adrian.klaver@aklaver.com =20 ------=_Part_257192_1224794649.1585670935975 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
FDW for oracle and ora2pg both are too slow compared to offload data in a file and load into PostgreSQL. When I was doing one of my migrations I found the best solution was to download data using sqlldr on to the database host where PostgreSQL instance is running and load it using COPY command.


Regards,
Virendra Kumar

On Tuesday, March 31, 2020, 8:55:17 AM PDT, Adrian Klaver <adrian.klaver@aklaver.com> wrote:


On 3/31/20 8:51 AM, Pepe TD Vo wrote:

> I have tables ddl data definitions already.  Only need to move the data
> over off Oracle to Postgres


PostgreSQL Foreign Data Wrapper for Oracle:

http://laurenz.github.io/oracle_fdw/


--
Adrian Klaver
adrian.klaver@aklaver.com



------=_Part_257192_1224794649.1585670935975--