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 1gjrVA-0001AN-Ir for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jan 2019 20:09:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gjrUB-0004rM-9C for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jan 2019 20:08:27 +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 1gjrR0-0005Fd-H5 for pgsql-admin@lists.postgresql.org; Wed, 16 Jan 2019 20:05:11 +0000 Received: from sonic306-3.consmr.mail.bf2.yahoo.com ([74.6.132.42]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjrQx-0000my-5O for pgsql-admin@lists.postgresql.org; Wed, 16 Jan 2019 20:05:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1547669103; bh=6n/I7Uj7ZpkEtm0S13LNGnK2gCQR0tM/eM1nzc9piMM=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=UkdqJ/M6fH9GgmFTVPLojYEGNlf6Wh4gkGfpZDDdUBLnqoWRgkGelbDOOE7dSFGs7DmaEkjmCFJRWEmMqml4OXj/09jYhMg88LxQSPaxrjLiVG98OYv+65yAcIWuVRfTVwex95cmWaFNFYkwuNHAQ2kxMtbP/syv46ui5gK0XDFp8MEwyRxgP28HN8GMhUI/6Chd9z7TMonuc42Dk6YHeVtFNd89ZoqbAM8aeqHS64Onw7NfJY25lZTdwgdCdH3585HfMX1wjR9k6tF55tV0Oqi/oq8lRl7AIXyzxDEGAE0rnNZu9x6/v3l2gKJ0/+fxbT9E7T5tHCXnA4wVrWZ3FA== X-YMail-OSG: .TbqdBcVM1nnOIqcqbSu_r1VHrGSH6GFJDONXFgPdLxPN7ANyOf7sPyI8MdhdN9 dpBcqcAp2s4G7th8ClZxT6uAlyEeYhxFANlvsrTARsCBxi7cHjidc_Lsk__KLbvcmKKN8t3mCCO1 Hb_412RpG0JzTskMO7ZFKQ581Y_5_jZJaAqTepnfKac8d3SUQkFLqtexLtRULWzzPRm_ixewZKr2 g7aMLHnMs7Db9C_pinraz3NI.vbjPYiJQXYUwL4w6rh3x6frBQf80WOkoy5hmuxdbK1gaA.NhxX1 kSLlPsIGxcSI3FGi4EwaPIKioMn9LFBMKnwClSfpiVy.Ur7wjxcaCKeYOezHWTMPZapdCdfdswzq 6w910auKiUnyvNfxYL3BldTy9rJRw_0lkhkSan9Knx5vNdot3YnzcJw_pf7eXGleQzSI4f9Oc9dG L6slxfK7DgbnZQn9WzvYhEFSDOpeYbAslahe8odA3xdj7V4oxcGPGP7.08uvLh5owWyzaWFBXwpA CTXWUqageKnVvo15UCZ1miio7YXiDAilmkDCTrwj13I9y9rmIG2ngryK.9LbuIKDy01zlCh99QtL EMJCTNxqFwS_myYrUb4ARh3QGZnDk5rco8.XGELzNyT7wuyQmWMS.iZXqW7cz3tvzBYREsiv1oio 2nCsdR0Hp1v2Kv9BlJNkCxf4zK9vkTsK2DHB3kgrJyLDPeOQXR3Cmi0ovVVAW8Rl7MZ1D3kVwWpf fReOuJozOllptACmis5vERYOYzgqHHaUwUDmvqhzAOGykQhlRUGD55hpKmYsP0g6m3BpLOeT_Z4l MWUm8rT_42xvx61GMQ0ETrE8OBl0FrQIFmy_jNAE2zvzez9bawqstFcPcnhTSB4I1c2MmNsULpUa URGjUawG2rX7Hiiiw3kUh04vOI1dd5pFghxMPASFjRoIi8qnBxjBA.Ae.08iAwD7iYe0syKUiS5D RQK7pMYXpDJcnfX_TGwNjKk5_4seQj_HOKhZW926ZKzfs_XfQEsZBYQk1ft9UJz9TOU.J9Lm0lE1 SJu7NKSopnUkHg6IT_oi9rtD04sojcMoVMhsdF4Yb759Ff2btAAfGC3f0F4fZurYT9wqBznFp Received: from sonic.gate.mail.ne1.yahoo.com by sonic306.consmr.mail.bf2.yahoo.com with HTTP; Wed, 16 Jan 2019 20:05:03 +0000 Date: Wed, 16 Jan 2019 20:05:00 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Shreeyansh Dba Cc: Pgsql-admin Message-ID: <732616782.754403.1547669100729@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> Subject: Re: Copying Data from Oracle to PostgreSQL MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_754402_1324380204.1547669100724" 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: 24715 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_754402_1324380204.1547669100724 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 - Where should I install ora2pg, in the oracle db server or postgres db = server? 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 ------=_Part_754402_1324380204.1547669100724 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I am able to download the ora2pg but I don't understan= d how it install. According 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, oracle-instantclient18.3-basic-18.3.0.0.0-1.= x86_64.rpm, oracle-instantclient18.3-basic-18.3.0.0.0-1.x86_64.rpm,&nb= sp;oracle-instantclient18.3-devel-18.3.0.0.0-1.x86_64.rpm, oracle-inst= antclient18.3-devel-18.3.0.0.0-1.x86_64.rpm.
  1. I can't find the ora2pg18.2 on gzip or zip but bz2.  = With this file I can't unzip it because the server didn't have this feature= .  Can I use ora2pg.19.1.tar.gz instead of version 18?  
    =
  2. Where should I instal= l ora2pg, in the oracle db server or postgres db server?

thank= you for your inputs.

v/r,

Bach-Nga

No one in this world is pure and perfec= t.  If you avoid people for their mistakes you will be alone. So judge= less, love and forgive more.
To call him a dog ha= rdly 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 k= new him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Ca= re deeply **Speak kindly.
*** Genuinely rich *** Faithful ta= lent *** Sharing success


<= div style=3D"font-family: verdana, helvetica, sans-serif; font-size: 16px;"= >
On Friday, January 11, 2019 11:42 AM, Shreeyansh Db= a <shreeyansh2014@gmail.com> wrote:


This sit= e works for us, there might be a security restriction at your end.

Thanks & Regards,
Shreeyansh DBA Team
<= a rel=3D"nofollow" shape=3D"rect" target=3D"_blank" href=3D"http://www.shre= eyansh.com/">www.shreeyansh.com


<= div dir=3D"ltr">On Fri, Jan 11, 2019 at 10:04 PM Pepe TD Vo <pepevo@yahoo.com> wrote:
Yes, I need migrate all the objects includin= g tables, functions, triggers, procedures from Oracle to Postgres.  Or= acle is on one server and Postgres is on another server.  =

https://ora2= pg.darold.net/documentation.html doesn't work. "

<= span id=3D"yiv7748736196gmail-m_-5260542759434306398yui_3_16_0_ym19_1_15472= 23428386_62089">This site can=E2=80=99t be reached

ora2pg.darold.net took too long to respond.
<= span id=3D"yiv7748736196gmail-m_-5260542759434306398yui_3_16_0_ym19_1_15472= 23428386_62092" style=3D"color:rgb(95,99,105);">
Try:"
<= /div>
 

thank you.

Bach-Nga

No one = in this world is pure and perfect.  If you avoid people for their mist= akes you will be alone. So judge less, love and forgive more.=
To call him a dog hardly seems to do him j= ustice though in as much as he had four legs, a tail, and barked, I admit h= e was, to all outward appearances. But to those who knew him well, he was a= perfect gentleman (Hermione Gingold)

**Live simply **L= ove generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful t= alent *** Sharing success


On Friday, January 1= 1, 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 from Oracle to PostgreSQL.

https://ora2p= g.darold.net/documentation.html 

<= /div>
<= div dir=3D"ltr">
Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com
=


<= div class=3D"yiv7748736196gmail-m_-5260542759434306398yiv9641168292yqt15769= 26499" id=3D"yiv7748736196gmail-m_-5260542759434306398yiv9641168292yqt59078= ">
On Fri, Jan 11, 2019 at 9:53 PM Pepe TD Vo <pepevo@yahoo.com> wrote= :

Hi Experts,

Is there a best tool for me to c= opying data from Oracle to PostgreSQL?  
The Oracle db named is Ci= dr and had a few schemas, each schemas owned their own tables, procedures, = triggers, functions.  If I create a database on Postgres, how do I cop= y all schemas from Oracle? Or each schema will become one of the postgreSQL= database?

thank you for your helps.

v/r,

Bach-N= ga

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 forgiv= e more.
<= font id=3D"yiv7748736196gmail-m_-5260542759434306398yiv9641168292gmail-m_-3= 012317369092772456yui_3_16_0_ym19_1_1547223428386_45724" color=3D"#8000ff">= To call him a dog hardly seems to do him justice though in as much as he ha= d 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 Ging= old)

**Live simp= ly **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Shar= ing success
<= /div>




=
------=_Part_754402_1324380204.1547669100724--