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 1jJK1P-0006Kg-8e for pgsql-general@arkaria.postgresql.org; Tue, 31 Mar 2020 16:45:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jJK1O-0002N1-4J for pgsql-general@arkaria.postgresql.org; Tue, 31 Mar 2020 16:45:50 +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 1jJK1N-0002LW-Dy for pgsql-general@lists.postgresql.org; Tue, 31 Mar 2020 16:45:49 +0000 Received: from sonic311-14.consmr.mail.bf2.yahoo.com ([74.6.131.124]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jJK1J-0002tJ-W3 for pgsql-general@postgresql.org; Tue, 31 Mar 2020 16:45:48 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1585673144; bh=xCKzTt/W/JK5Q91C+p0k70Ay+UVg9AuFpDDeapMjMHk=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=pgNr7SmD35uRRiX8XF4Vk4lOLYQDbHeB3WbgEaD1wYBCSTfFY3nL+ndIW2247TrcPMVGof7kFUcRsWqQPi3u4sKQaUNm/zvZJPksicXVzG69xLNr/XAq9QG/4cq1xk19k+mxS22R/uMsKkUjYSK9jwibDXAiN0MXAcxGyiQWC29bo08RuR6DeG9CBbb+qbqTqEOk8pewR/Fz0F/FmjcJPh9a0dFWTXccqRSeMDJudq+NZ2BGl7dcoHFU2k4Biq/eT3XXRZNZcBQxkEXRY20DxSCkKQdlhkAT8fp0y3N7JEYYIF46iUti8a2HTO/gAScLWakovb462ZcLljTuO6OIKA== X-YMail-OSG: 4zENFVsVM1kMXo9xkINkzR7vfOolpgZwGHJYR1Tl5OmHjZ0WTu5mWH0gqRjJVdT NK7deMOilBIXy2GykE0L29rQmBNudYqRs1VBBRwc8HBfylKO.5SghVyqffUhZG8_1IxfLPsVlGyj MRRqPsWx28mN.L5JYO9_aaWRO5nznpxajYCApG_E2EBvcUxStRdKxPhhrOJY5UrbWmdk4dGooWdh vyB7IKiv2V_m.MATOUhWDypIhtnWAzG.U5k9zbdXv_pD57N99az8_DQMwGnWBo1gQKtG4LFtqKnU UGNrgI6b8hEGgfcy5e7u4J8cgyoOvjWXqgxICgqKLgxfLMe7OWDAjP_TbGRbq9hbrdEN6.xkmlby 5NDYMcvx6jKuowTyaUFvcSeyM2lbqhlF3ad_fLS9jMMdYlPnaEaqeIMewBdUOkV8vw8X.TcDbCGx YaPyOBLz.s1oV2a9rinTZtdx9Ay9Ezm80L6pgIlyQsLa.LSzUIn3jCqsk309q6LUMwDSNdPf7XEd ZgPkaC8bZpkYmYXCFeNgBio5JjysedIuJIrMSCOK3FyMHmsGy5li.dDxmU92lsxv60_hR_tlgoIP X.zMDgQVyhkd_QT7TiZh.zK8W19z05n97205mxPAG_6N1pH10uf2KE9i4v5wVZ5hu__uUXp.JtOE rK6nx9GfHrSPLmz7IzrWiMskEZ6jAEsOuEjJdu2khsCKxeKcxfS1lQX4gEtAVq4xMgPeksr77Ixo IKWoAQuzX78FctsXf8Er9S1oDdNt6oJmmKszpTZI.768G6jfZK3PJP1L1dNLXITze_ZIgKePFIca vuPGzpMvrxGxZkGYZAagZTTsq9akmbt1OPtbzvrJbZ12PbDpYgqxwsNKIqYVlG.X7gLa4bU1oCP_ W7mV.XF6zq4gCKviICfGju8y73w0L631ej26sWbXDPnF5V7kbeEW8S0_tRJaoqBT.7XleOOFcby8 6qF10tFOvI9t5c18avg0B3THQcr7WShKL9j_YlP1yjGvewLjUhq9dbgClpyDD0v6NXV9PS_1dcR8 8vw49G9Avcg49yLRpaipVcVcq.iuyMvPG7tyVeWNYkjmrF76kzE1GDprnpducq9pcV4goY0oJjH3 Ud4IqFX3TJRRcm1qxhebrhRTS_.cbni5441m8KNWVcZCAqIbFjcTbQ53XbROTLHofKH1EvSfxxnT k5F8yXM23yoXVrwznsFdEZTmYi.SzdAsjKT.QJmqvpue5FmTAdi3lrujX7ETAdvCilxO8OAE.Vcb CEcNpq4FJMzizXrpFrF5oP6RgsR4imb2OJpqv1N7OY8YK9Xy5RBRETjKPXfmklN3.sctIVvpmogu FCk8EUQF5d1AOmEafvHKACImjqBOyn3vF1nW7T4e7lA-- Received: from sonic.gate.mail.ne1.yahoo.com by sonic311.consmr.mail.bf2.yahoo.com with HTTP; Tue, 31 Mar 2020 16:45:44 +0000 Date: Tue, 31 Mar 2020 16:45:43 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Pgsql-admin , Pgsql-general , PgAdmin Support List , JC JC Message-ID: <743748782.1183492.1585673143662@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_1183491_297377708.1585673143659" 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: 20570 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1183491_297377708.1585673143659 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable @JC - I do have ora2pg set up last year in test environment already and tha= t what I suggested team using insert script to run in Postgres.=C2=A0 And I= am not sure how long it would take to load? 1T data. Though if there's a t= ool liked MySQL workbench to pull the oracle export data pump and import in= to MySQL. 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, 12:09:13 PM EDT, JC JC wrote: =20 =20 #yiv7970034777 P {margin-top:0;margin-bottom:0;}I am sure you might be ref= erring this=C2=A0https://ora2pg.darold.net/documentation.html=C2=A0 You need to create ora2pg conf file with TYPE COPY, and ALLOW and remaining other attributes like=C2=A0ORACLE_DSNO= RACLE_PWDORACLE_USER similarly=C2=A0PG_DSNPG_USERPG_PWD=C2=A0etc=C2=A0etc. Cheersjc From: Pepe TD Vo Sent: 31 March 2020 16:51 To: Pgsql-admin ; Pgsql-general ; PgAdmin Support List ; JC JC Subject: Re: migrate off oracle data to postgres=C2=A0I have tables ddl=C2= =A0data definitions already.=C2=A0 Only need to move the data over off Orac= le 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 On Tuesday, March 31, 2020, 11:46:58 AM EDT, JC JC 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 attributes set in ora= 2pg 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 remai= ning 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 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_1183491_297377708.1585673143659 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
=
@JC - I do have ora2pg set up = last year in test environment already and that what I suggested team using = insert script to run in Postgres.  And I am not sure how long it would= take to load? 1T data. Though if there's a tool liked MySQL workbenc= h to pull the oracle export data pump and import into MySQL.<= /div>

Bach-Nga

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

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


=20
=20
On Tuesday, March 31, 2020, 12:09:13 PM EDT, JC JC <= shekharjchandra@hotmail.co.uk> wrote:


I am sure you might be referring this 

You need to create ora2pg conf file with TYPE COPY, and ALLOW <LIST OF T= ABLES separated by space> and remaining other attributes like 
ORACLE_DSN
ORACLE_PWD
ORACLE_USER

similarly 
PG_DSN
PG_USER
PG_PWD 
etc 
etc.

Cheers
jc

From: Pepe TD Vo = <pepevo@yahoo.com>
Sent: 31 March 2020 16:51
To: Pgsql-admin <pgsql-admin@postgresql.org>; Pgsql-general &l= t;pgsql-general@postgresql.org>; PgAdmin Support List <pgadmin-suppor= t@lists.postgresql.org>; JC JC <shekharjchandra@hotmail.co.uk>
Subject: Re: migrate off oracle data to postgres
 
I have tables ddl data defi= nitions already.  Only need to move the data over off Oracle to = Postgres

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


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




Fr= om: 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 a= s 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 perfe= ct gentleman (Hermione Gingold)

**Live simply **Love genero= usly **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success
------=_Part_1183491_297377708.1585673143659--