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 1jJJB5-0008Sc-9D for pgadmin-support@arkaria.postgresql.org; Tue, 31 Mar 2020 15:51:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jJJB3-00067J-Vn for pgadmin-support@arkaria.postgresql.org; Tue, 31 Mar 2020 15:51:45 +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 1jJJB3-00067C-Gl for pgadmin-support@lists.postgresql.org; Tue, 31 Mar 2020 15:51:45 +0000 Received: from sonic312-20.consmr.mail.bf2.yahoo.com ([74.6.128.82]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jJJB0-0002Md-G4 for pgadmin-support@lists.postgresql.org; Tue, 31 Mar 2020 15:51:44 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1585669900; bh=Bht3/DkzO4KfiFoRfC3wsLZ93N9YhiCFu0tdk21xT84=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=rVyrW7d8R3b+g/4WPrg6S/EWGSLyOuDTJKO1NhbraR7E0Ghe6QHKonN7z/pemxRelf6c84GXzyWoWrwiSdIDuDbsyoS1xfuBjqoWi/EGZxphJE3e1U7R2ngH/WDszDd7hrNIIgqNgbcDrzdbWVYRzRTMHitpSNphCzed78L/HNWFjso1zgkdDHAeZ7tVkgW+MhgbFwu+GgbbypSxH/6/atcUQeqzAb1vv8sHuhNtX6M7s/sCRJElyJmqv5rJG6VGul4IkGHwwI3C7VxK0MZlhbOwDE0voCc7ZOnoNT0/r3sA14RyqlWzr4GUmF8xdraRBlc4DoRZItmDyHDGp8NtGQ== X-YMail-OSG: xSZWvp4VM1kK5XidRm953XPg3Te0oIH0EeYhfOopXLfs.offpvoBkQwrMUvnYQ0 e8nzmZEXYQ1K8wLRIU8TIo0CJaGdQRaT1F95nvO.MsUPeqEZVHi1d3RGCaoq8EyBBOi4Vdyaz5e8 h112Fuuy7X9ckGrx6ptIh2fJmD7SK9HBwNTtCUPl.d5pjdKmPUOnVl3avWtzsfTTuRU4_tnNDeAd 5rrnSsbuSpyHNcpuswi5bxz15T_5iGsSCEayAFcyMg9wdwBIbuKZiHDLsPXgNLXmyFOXFSpysixU Jqa1X20nVHyI1zWyjDRkxjdLzwRyEFz7MiCR_.A0Nh6Inp3uuguzgQuIHLLZhWgrTl7mmjxCbSVZ eM5GPqtLACEVfctsBtd9cFNLIvTzo0lNrAISFSjzoOlX1O_8aftNdkKsrd4yELUlTmW9qlwSKItg 3j_A1KXrYo_nEv2ZAWkxgwILlyng.ySbV3GcKisV1H3wp3m.k04Mhobw9VENFkyX_TtiYrHfd3q6 _Li7uB.HAJpd0eRg1HTZmPZM2M0BSHk2QtI456LKVxXMzMCMAoj.tD9h27zmJjwXn94eVxUPrHic jtQ6WuniZV40176F1JuExFF7FTdD3Vb49RzxNjvNZbBS3vJdI2k.jeWUo4QXhqt2oooV5Ln26nE9 .ZhqmoUePLiGuMJ5id1vSmSAlaXGJ.zOZ5zDOR0EouDjHLMmjpbneIbptGeVy1K2ZP3ZyLq3hQFQ y_oesSBcujpFpT7Fo8g_YAYYI3KAKtdReK.CNc_9z3dBJ9tzSQsf5YSbKlNl9CLVyA5cEwVMIZBy iDa6G07gZwY4M_T8bCjqOiVA5aoziDJgDelcHn0sXDkmWxvLo.xPi6_2ArsvK_P5dNinesgKOsKn c_VbIcREsZYAWdjuteGU8hbz1imVB3slhKHFtaaIvbFfwNWX9oQ58WomwZQon7ILDZpwpaUbe9hL KEDijpmn7ABRy.zllraJ3dounTMxDE3T03vPioP5eFzxHb81MiUCQF4fyx7ffijsAGZ8.KRcVQro 7gqWpg.1olNDF8_VUsnDn.36ShURdCXoPO_r5r7Whu_WMtDJWwk0KOglB8FYo3oK.Wf1B6V5qUBj iHU7iZEmcYMiaVbDVUW45aUJvh57rTNUTKXxZoG_PyoPMpFxVFzpOXHCfJWQxVq4n5QZj7EsUBwm LiBrvrkw4.xhtCnsf4S.pmB32MB74jCZBE5Cq3mn21SOxiMgb2OuaHC1sDR61jgvToIxCJQT5ldf AxdfY.6vfjxzHzh6VWQPgiLP8rCTA6BmQIVORQorM9O.UEgBrLqF_yDMvweH9AUCQSoeDez3jUmR 4LngZ1Xs0FJl5wF.Kh8w9QreFlGzv92CcjgCQ8IjBMg-- Received: from sonic.gate.mail.ne1.yahoo.com by sonic312.consmr.mail.bf2.yahoo.com with HTTP; Tue, 31 Mar 2020 15:51:40 +0000 Date: Tue, 31 Mar 2020 15:51:35 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Pgsql-admin , Pgsql-general , PgAdmin Support List , JC JC Message-ID: <1493124385.1141236.1585669895986@mail.yahoo.com> In-Reply-To: References: <1587437647.1103378.1585664119295.ref@mail.yahoo.com> <1587437647.1103378.1585664119295@mail.yahoo.com> Subject: Re: migrate off oracle data to postgres MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1141235_204615724.1585669895983" 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: 11778 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1141235_204615724.1585669895983 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I have tables ddl=C2=A0data definitions already.=C2=A0 Only need to move th= e data over off Oracle to Postgres 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 Tuesday, March 31, 2020, 11:46:58 AM EDT, JC JC wrote: =20 =20 #yiv3534479505 P {margin-top:0;margin-bottom:0;}In my view ora2pg can do m= ost of the stuff you requested.ora2pg can be used to generate the DDL from = oracle to postgres based on attributes set in ora2pg conf file (for example= TYPE TABLE, will allow getting oracle DDL in an output file, TYPE COPY wil= l bring the data). No doubt you need to set remaining attributes based on t= he requirement. Export to CSV is not required, as mentioned TYPE COPY will do a load of dat= a if you like it to do Direct Data Streaming.As of my limited experience I = never encountered any issue on the limit on data being transferred, but def= initely the load time vary depending on the environment. Regardsjc From: Pepe TD Vo Sent: 31 March 2020 15:15 To: Pgsql-admin ; Pgsql-general ; PgAdmin Support List Subject: migrate off oracle data to postgres=C2=A0Hello, 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 =20 ------=_Part_1141235_204615724.1585669895983 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I have tables ddl data definitions already.  Only need to move the= data over off Oracle to Postgres

Bach-Nga

No o= ne in this world is pure and perfect.  If you avoid people for their m= istakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice t= hough in as much as he had four legs, a tail, and barked, I admit he was, t= o all outward appearances. But to those who knew him well, he was a perfect= gentleman (Hermione Gingold)

= **Live simply **Love generously **Care deeply **Speak k= indly.
*** Genuinely rich *** Faithful tale= nt *** Sharing success


=20
=20
On Tuesday, March 31, 2020, 11:46:58 AM EDT, JC JC <= shekharjchandra@hotmail.co.uk> wrote:


In my view ora2pg can do most of the stuff you requested.
ora2pg can be used to generate the DDL from oracle to postgres based on att= ributes set in ora2pg conf file (for example TYPE TABLE, will allow getting= oracle DDL in an output file, TYPE COPY will bring the data). No doubt you= need to set remaining attributes based on the requirement.

Export to CSV is not required, as mentioned TYPE COPY will do a load of dat= a if you like it to do Direct Data Streaming.
As of my limited experience I never encountered any issue on the limit on d= ata being transferred, but definitely the load time vary depending on the e= nvironment.

Regards
jc




From: Pepe TD Vo = <pepevo@yahoo.com>
Sent: 31 March 2020 15:15
To: Pgsql-admin <pgsql-admin@postgresql.org>; Pgsql-general &l= t;pgsql-general@postgresql.org>; PgAdmin Support List <pgadmin-suppor= t@lists.postgresql.org>
Subject: migrate off oracle data to postgres
 
Hello,

I have a huge data on Oracle, would you please suggest how= to migrate all data off Oracle to Postgres?  Do I need to expor= t into csv and upload to postgres?  Ora2pg is limited data from = oracle to postgresql right?


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 l= egs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (H= ermione Gingold)

**Live simply **Love generously **Care dee= ply **Speak kindly.
*** Genuinely rich *** Faithful talent ***= Sharing success
------=_Part_1141235_204615724.1585669895983--