Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gk7dv-0003Tq-HH for pgsql-admin@arkaria.postgresql.org; Thu, 17 Jan 2019 13:23:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gk7ds-00079D-UU for pgsql-admin@arkaria.postgresql.org; Thu, 17 Jan 2019 13:23:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gk7ds-000795-4g for pgsql-admin@lists.postgresql.org; Thu, 17 Jan 2019 13:23:32 +0000 Received: from sonic304-11.consmr.mail.bf2.yahoo.com ([74.6.128.34]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gk7do-0006gA-5M for pgsql-admin@lists.postgresql.org; Thu, 17 Jan 2019 13:23:30 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1547731405; bh=iMdIPrcbzcLX39T2DEzUBS7KbWgkoSLZ2EInBT1f+tM=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=QlqLT7m0IOO7y7zDo+QCT747fQAhqF6GS2q0JFHOGyTugT7F/xIPDm6wzvuHElWnHBkDhAD/DC971fAfAjS02VlBy1clc6lNAZ80IULZkgTWyclo138nWZgoA03Et5Ub51OEHPjRKLt4G4S0RNtwumsMZaf2bsODUp84Te3lUKIH9xGEZLGZ6IcvuUxjQqrug0fJGGT8qwxOWfUuUCrhkl7/LUjqNu891OePRb9QKTR+bod8NkvwE6GFuFSkUx74ReIcRQ/484HtHDiYIcixmv1BRsuVU9Ds3z9gQD5DMGc67EoXJeod+Hojx+x4FgbddY1DiraSb/XJUoObB7G6qQ== X-YMail-OSG: JEQZ3qAVM1lCyulNY7Wghm.47V0M_RiVSvqcbFD2PfDtRqoL0Ww8ytLZkO4A2.w fk2ayQYRp8OCFmqd9YEw0ddZwmL6iyhLnk113R_.qE93LCSDoq.DzhaTMfVwEhaeSS.JcYS7lDzw WmLjHL7g_dYnurdcL4sITNY3byJs8ubt0Fqjdi0QzmlcaWr8Wwf7l.zWxJjOaHdvLjz4rB3soes_ Zh88KUuer42c0SryM2UvMEWaBN1gSTiBZJv6ygYKt6TEtJqoFkVQig4aG7DdatlYXSAx7tHySR0X Ts_QTCoyoB5iRAypmxWdZsKb222ogE2.iOGLJ5_FGZNNn1Z79fGCpBKpOxxFIsl5y8QRO6XsJ_oK lT.CaXZPTrF6mmSfaEMiAn2WKza4EYOram4XFsiyPdTsDVcMGldTCgfcBvwAOFU_1dNDvYLE2IQG 3tH1C6R8d85DbB0bs2q.Ze98WaqHLW.J4DaXJropaclT5VUdXHKQnnfO0MXojG.8uFbfMM.S5AED x8fbzqVY3D9vQeXxzKuuULK4ZqdVjm4YGDI9gN3jri3MJc5zzKhJJec6vzpXfkgVdQhhSPgEWLcG cqlaCnuu23dEDThqc0Kv27iq02X91N923OCe.9cmdLjuBWwFYaI1_spjMi3G_xzKlf52HnERyYt7 OULqAN8ePJ53XA5kKFkUnJPnkVO3AmJ.QEKHAyc5x3_NRbAgP4F_ncy4EEsAmEXX1S6B6NiMVpRQ Ar5hKQZc5zsKNOoxwHgRpYL7k_CsO9RVEuF0l4Sm_BJBdiGsAyIdx5DxT7TE3L13mr.JwWfaX8tt yDxYOBrfpi_A3J3.rBWwqscuPaU29e2MMbs3ih.vhm7e159aW.qOEuBhCzG.LswTp3Q2bGrX7vwT p0v3p26Stcd.3b5e9swZUjNkRi8RBMP61FRmSgAV4kQG_f8H5FK8rVmt7I8C2xevoCwcDKA0FG0x YoBEg_A9Oe1o7AHugnDRg_SErZFS7oBOuuMerKLT80E6vtWavCtJyp_KAQOLNYAo9DvW4csxB7YG kJwY3KMoyvN.FoOpL_JUF9BoRGXbVkq7PaIca37xXDNyHi6q6aC8Qs7T1ie1ZsUCMRGzG6Qs- Received: from sonic.gate.mail.ne1.yahoo.com by sonic304.consmr.mail.bf2.yahoo.com with HTTP; Thu, 17 Jan 2019 13:23:25 +0000 Date: Thu, 17 Jan 2019 13:23:22 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Shreeyansh Dba Cc: Pgsql-admin Message-ID: <1744507602.1095304.1547731402192@mail.yahoo.com> In-Reply-To: References: <1382151693.17038706.1547223778133.ref@mail.yahoo.com> <1382151693.17038706.1547223778133@mail.yahoo.com> <560782983.17074510.1547224489903@mail.yahoo.com> <732616782.754403.1547669100729@mail.yahoo.com> Subject: Re: Copying Data from Oracle to PostgreSQL MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1095303_133058301.1547731402186" X-Mailer: WebService/1.1.12857 YahooMailNeo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36 Content-Length: 39327 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1095303_133058301.1547731402186 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Shreeyansh, Thank you for your input.=C2=A0 I installed ora2g on both Oracle DB and Pos= tgresql DB servers.=C2=A0 Since these two servers are main database servers= , do I still need install extra Oracle Client and PostgreSQL client on that= each two servers? thank you. v/r,=C2=A0Bach-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 Thursday, January 17, 2019 4:01 AM, Shreeyansh Dba wrote: =20 On Thu, Jan 17, 2019 at 1:35 AM Pepe TD Vo wrote: I am able to download the ora2pg but I don't understand how it install. Acc= ording to the document I found on net that yum install perl-DBD, perl-dev, = and perl-CPAN and all oracle-instantclient18.3-sqlplus-18.3.0.0.0-1.x86_64.= rpm,=C2=A0oracle-instantclient18.3-basic-18.3.0.0.0-1.x86_64.rpm,=C2=A0orac= le-instantclient18.3-basic-18.3.0.0.0-1.x86_64.rpm,=C2=A0oracle-instantclie= nt18.3-devel-18.3.0.0.0-1.x86_64.rpm,=C2=A0oracle-instantclient18.3-devel-1= 8.3.0.0.0-1.x86_64.rpm. =20 - I can't find the ora2pg18.2 on gzip or zip but bz2.=C2=A0 With this fi= le I can't unzip it because the server didn't have this feature.=C2=A0 Can = I use ora2pg.19.1.tar.gz instead of version 18?=C2=A0=C2=A0=20 You can download the ora2pg18.2 on zip or tar.gz from below link.https://gi= thub.com/darold/ora2pg/releases =C2=A0 =C2=A02. Where should I install ora2pg, in the oracle db server or p= ostgres db server? You can install ora2pg either Oracle server or PostgreSQL sever or elsewher= e. But must be have installed the Oracle Client Application and PostgreSQL = Client (psql) Application on that server.=C2=A0Thanks & Regards,Shreeyansh = DBA Team www.shreeyansh.com thank you for your inputs. v/r, 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, January 11, 2019 11:42 AM, Shreeyansh Dba wrote: =20 This site works for us, there might be a security restriction at your end. Thanks & Regards, Shreeyansh DBA Team www.shreeyansh.com On Fri, Jan 11, 2019 at 10:04 PM Pepe TD Vo wrote: Yes, I need migrate all the objects including tables, functions, triggers, = procedures from Oracle to Postgres.=C2=A0 Oracle is on one server and Postg= res is on another server.=C2=A0=C2=A0 https://ora2pg.darold.net/documentation.html=C2=A0doesn't work. " This site can=E2=80=99t be reached ora2pg.darold.net=C2=A0took too long to respond.Try:"=C2=A0 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, January 11, 2019 11:31 AM, Shreeyansh Dba wrote: =20 Hi, You can use ora2pg which is one of the best tool for data migration from Or= acle to PostgreSQL. https://ora2pg.darold.net/documentation.html=C2=A0 Thanks & Regards, Shreeyansh DBA Team www.shreeyansh.com On Fri, Jan 11, 2019 at 9:53 PM Pepe TD Vo wrote: Hi Experts, Is there a best tool for me to copying data from Oracle to PostgreSQL?=C2= =A0=C2=A0The Oracle db named is Cidr and had a few schemas, each schemas ow= ned their own tables, procedures, triggers, functions.=C2=A0 If I create a = database on Postgres, how do I copy all schemas from Oracle? Or each schema= will become one of the postgreSQL database? thank you for your helps. v/r, 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 =20 =20 ------=_Part_1095303_133058301.1547731402186 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Shreeyansh,

Thank you for your input.  I installed ora2g on both Oracl= e DB and Postgresql DB servers.  Since these two servers are main data= base servers, do I still need install extra Oracle Client and PostgreSQL cl= ient on that each two servers?

thank you.

v/r,
 
B= ach-Nga

No one in this world is pu= re and perfect.  If you avoid people for their mistakes you will be al= one. So judge less, love and forgive more.
<= font color=3D"#8000ff" id=3D"yui_3_16_0_ym19_1_1547730808422_19019">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 ge= nerously **Care deeply **Speak kindly.
*** Genuinely rich **= * Faithful talent *** Sharing success


On Thursday, January 17, 2019 4:01 AM= , Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:
=

On Thu, Jan 17, = 2019 at 1:35 AM Pepe TD Vo <pepevo@yahoo.com> wrote:
I am able to download the ora2p= g but I don't understand how it install. According to the document I found = on net that yum install perl-DBD, perl-dev, and perl-CPAN and all oracle-in= stantclient18.3-sqlplus-18.3.0.0.0-1.x86_64.rpm, oracle-instantclient1= 8.3-basic-18.3.0.0.0-1.x86_64.rpm, oracle-instantclient18.3-basic-18.3= .0.0.0-1.x86_64.rpm, oracle-instantclient18.3-devel-18.3.0.0.0-1.x86_6= 4.rpm, oracle-instantclient18.3-devel-18.3.0.0.0-1.x86_64.rpm.<= /div>
  1. I can't find the ora2pg18.2 = on gzip or zip but bz2.  With this file I can't unzip it because the s= erver didn't have this feature.  Can I use ora2pg.19.1.tar.gz instead = of version 18?  
You can download the ora2pg18.2 on zip or tar.gz from below l= ink.
https://github.com/darold/ora2pg/releases=
<= font size=3D"4">   2. Where should I install ora2pg, in the oracle db server or postgres db se= rver?
You can install ora2pg e= ither Oracle server or PostgreSQL sever or elsewhere. But must be have inst= alled the Oracle Client Application and PostgreSQL Client (psql) Applicatio= n on that server. 
Thanks & Regards,
Shreeya= nsh DBA Team
www.shreeyansh= .com

thank you for your inputs.

v/r,
Bach-Nga

<= /b>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 h= im justice though in as much as he had four legs, a tail, and barked, I adm= it he was, to all outward appearances. But to those who knew him well, he w= as a perfect gentleman (Hermione Gingold)

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


On Friday, Januar= y 11, 2019 11:42 AM, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:


<= div class=3D"yiv8159081949gmail-m_3782808230151975516yiv7748736196" style= =3D"font-size:small;">This site works for us, there might be a security res= triction at your end.

Tha= nks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Fri, Jan 11, 2019 at 10:04 PM Pepe TD Vo <pepevo@yahoo.com> wrote:
= Yes, I need migrate all the objects including tables, functions, triggers, = procedures from Oracle to Postgres.  Oracle is on one server and Postg= res is on another server.  

=

This = site can=E2=80=99t be reached

ora2pg.da= rold.net took too long to respond.
Try:"
 

thank you.

Bach-Nga

N= o one in this world is pure and perfect.  If you avoid people for thei= r mistakes you will be alone. So judge less, love and forgive more.<= /span>
To call him a dog har= dly 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 kn= ew him well, he was a perfect gentleman (Hermione Gingold)

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


=
=
On Friday, January= 11, 2019 11:31 AM, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:


Hi,
You can use ora2pg which is one of the best tool for data migration fr= om Oracle to PostgreSQL.

https://ora2pg.darold.net/documentation.html 

<= div dir=3D"ltr">
Thanks & Regards,
Shreey= ansh DBA Team
www.shre= eyansh.com
=


On Fri, Jan 11, 2019 at 9:53 PM Pepe TD Vo <pepevo@yahoo.com> wrote:

Hi Expert= s,

Is there a best tool for me to copying data from Oracle to P= ostgreSQL?  
The Oracle db= named is Cidr and had a few schemas, each schemas owned their own tables, = procedures, triggers, functions.  If I create a database on Postgres, = how do I copy all schemas from Oracle? Or each schema will become one of th= e postgreSQL database?

thank you for your helps.

v/r,=

Bach-Nga
=
No one in this world is pure and perfect.  I= f you avoid people for their mistakes you will be alone. So judge less, lov= e and forgive more.
<= font id=3D"yiv8159081949gmail-m_3782808230151975516yiv7748736196gmail-m_-52= 60542759434306398yiv9641168292gmail-m_-3012317369092772456yui_3_16_0_ym19_1= _1547223428386_45726" color=3D"#0000ff">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 perfe= ct gentleman (Hermione Gingold)

**Live simply **Lov= e generously **Care deeply **Speak kindly.
*** Gen= uinely rich *** Faithful talent *** Sharing success


<= /div>



<= br> ------=_Part_1095303_133058301.1547731402186--