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 1gjruS-0002eu-3a for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jan 2019 20:35:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gjruP-0007b7-KK for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jan 2019 20:35:33 +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 1gjruP-0007P2-2n for pgsql-admin@lists.postgresql.org; Wed, 16 Jan 2019 20:35:33 +0000 Received: from sonic313-14.consmr.mail.bf2.yahoo.com ([74.6.133.124]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjruH-0001OD-21 for pgsql-admin@lists.postgresql.org; Wed, 16 Jan 2019 20:35:31 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1547670923; bh=4LiOz2/1btg+9Ts6SOK3jNvkaCiqQFFrDUxZZVYo8zE=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=HAGfV8hJqKcYIPpUjIr86OO8NdBgXGt6VhmXfp17eNQADp646POrFET9hpqPskx54SAw5vaWQmojEiWDEvq9L/cjcZ3WCeoitMdJltlO3R0geHcxjV1ktd9L4QI9TjBkNupUoiz0s/VSf+zuSrkRqwpqVPNlUiFIXUDG50agzueUZlWiMSPdzZ7lBEDU6lSW8NfeSZbiEtc3si2cpXTurbOis3tRw5ztw9mL1YIH4nHAU0rQcngL6Tn1Y9KdVzmU5wh/52kXnUE257uT/OHygCgI3s9+oQIUh0icLTPaW34o+PKC4hNEHhoIEES+vFYcK2bQgufolbP42Lc194Wqqg== X-YMail-OSG: dNOPiVcVM1lNGC4kjpmPfGjcbAcGOce5ZpN9KEAM6Hi.NAnneou6pbVGQMh1ISS DPyjViwQ5wjUX64cNw8UvW_7bhiLJYe62jQhg.Mn8SBJCeWikBgmNJnvp_oZtEkHEv8381DrQ8Xu 6.udkvCJTTswTUss1ATD_lGcRS3ZvZWXbElFWLN4Z5_U7a5tjATmqA0gRJns1Z0_8b7ERZKJTEpp EiXBBE0zNZ2mlrjL2WJmrQmMVTxS92cAHigCBOoNAOoEpRhHsVqMHfpzXLXnb5Tx5XDDBQToMrcL DNDuO6.Ag93IDXWI8pggfXhnRjNJRumpiGlg3_srGsM4qgezzdn3I2g7KGIApYR7k5nR_x5OIMXj RSiZ6wT9c5RUH57igFjMCbcllJYZxtc82ia_.hxCoiCyYRdDVmycOj9ZeEAQtjSBUoR2rnW0W.1L 1TaLBKhmU.e7IfR4.pVUqE49xgV_qZ9B.5UgvwJHcRCo2KTFF8hpGffAtSAjw.KKD8nYqUfq59ZO 5iNwFT2UKnNYZzFff2zmL8e1poUBeqNY3U8BRzdkW1vQa7m9mUwj_azvVV7VkX9gx9JhLm3BByOb YGLu_NUj6cJvOwQFcxLKz31J0ezu3bRBkM4vSdBiFbH8MMSOE5EBTimg0JgvyiWgUrV7FB853NNG MBAV1gWKh9kMB8GWA4J9LXBmMH20PH1xWBHGpvfzXdqRdq5.EBRPrdC5eIOyswB.FB1wJIJ_3kSd 1uRxE6hOCox9kb8mHxGKfowY5qmJwF3PA5SgDRyZSAvWuVdaABdBQeuL_jeJeWEd2lNCErZC9CCc ZFBTQQxWN1Iyt7_WS0G3Pn3WJSvBPX2.gEp53sTiGcustwBC0UGM60GuThHHakx9_OkV9qK6x83X pIh9IM4BpQBdNG5pjLTVMBDm0Hz9m8BTeKxx1EBleVtOAEsb.7ECuEAu8eJA8pahvWyEnYob_W5g 7nlzTFL640LSPIUphc2Zf3YEBaMEYjII1_FGzmf_de7w7aA1JXHgitX8t6FWz9zkqAzaMWBUDy_F R.tv4ehzbHri4WV2pqdVwihU4wfaLD.uz.tA99akJB6ZxiDP7FqWP5k9Uehu7a9UCZ0g.qLQdT4I TCGoRr82SBlnIEIG9LE0c_Bvbv5TdILqhma4TnXM- Received: from sonic.gate.mail.ne1.yahoo.com by sonic313.consmr.mail.bf2.yahoo.com with HTTP; Wed, 16 Jan 2019 20:35:23 +0000 Date: Wed, 16 Jan 2019 20:35:18 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: "gilberto.castillo@etecsa.cu" Cc: Shreeyansh Dba , Pgsql-admin Message-ID: <446111583.758900.1547670918954@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> <8b2bd545ff5c18410548e6e2fcb99a4e@etecsa.cu> <1492323826.781728.1547669875527@mail.yahoo.com> Subject: Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_758899_1853853052.1547670918952" 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: 22021 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_758899_1853853052.1547670918952 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Need to download oracl-fdw?=C2=A0 It's hard to go thru so many processes, n= eed to download, transfer information to somewhere, ask for permission to= =C2=A0burn into a CD/DVD,=C2=A0burn a CD/DVD, file a paperwork to move soft= ware from CD/DVD to server. Is there a way I can use those software already downloaded and transferred = to the server?I am asking where should I install ora2pg?=C2=A0 on oracle db= server or postgres db server?=C2=A0 I saw DBD-Oracle-1.52 tar and DBD-pg-2= .19.3.tar,=C2=A0http://ora2pg-samrat.blogspot.com/=C2=A0but didn't say whic= h one is install on which? the information is not really clear and may you help me out? thank you. =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 Wednesday, January 16, 2019 3:23 PM, "gilberto.castillo@etecsa.cu" <= gilberto.castillo@etecsa.cu> wrote: =20 =20 Answer interline. El 2019-01-16 15:17, Pepe TD Vo escribi=C3=B3: > sorry to ask, what is oracle_fdw oracle_fdw is extension for pg (foreign data wrapper) > do I need to download this oracle_fdw and where should I install it, > on oracle server or postgresql server? You can to install in pg server or wherever. >=20 > thank you. >=20 > Bach-Nga >=20 > No one in this world is pure and perfect.=C2=A0 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 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 Gingold) > **Live simply **Love generously **Care deeply **Speak kindly. > *** Genuinely rich *** Faithful talent *** Sharing success >=20 >=C2=A0 On Wednesday, January 16, 2019 3:09 PM, "gilberto.castillo@etecsa.c= u" > wrote: >=20 > Hello >=20 >=C2=A0 You may to use oracle_fdw >=20 > El 2019-01-16 15:05, Pepe TD Vo escribi=C3=B3: >> I am able to download the ora2pg 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-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, >> oracle-instantclient18.3-devel-18.3.0.0.0-1.x86_64.rpm, >> oracle-instantclient18.3-devel-18.3.0.0.0-1.x86_64.rpm. >>=20 >>=C2=A0 =C2=A0 * I can't find the ora2pg18.2 on gzip or zip but bz2.=C2=A0= With this > file >> 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 * Where should I install ora2pg, in the oracle db server or > postgres >> db server? >>=20 >> thank you for your inputs. >>=20 >> v/r, >>=20 >> Bach-Nga >>=20 >> No one in this world is pure and perfect.=C2=A0 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 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 Gingold) >> **Live simply **Love generously **Care deeply **Speak kindly. >> *** Genuinely rich *** Faithful talent *** Sharing success >>=20 >>=C2=A0 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. >>=20 >> Thanks & Regards, >> SHREEYANSH DBA TEAM >> www.shreeyansh.com [2] >>=20 >> On Fri, Jan 11, 2019 at 10:04 PM Pepe TD Vo > wrote: >>=20 >>> Yes, I need migrate all the objects including tables, functions, >>> triggers, procedures from Oracle to Postgres.=C2=A0 Oracle is on one >>> server and Postgres is on another server. >>>=20 >>> https://ora2pg.darold.net/documentation.html [1]doesn't work. " >>>=20 >>> THIS SITE CAN=E2=80=99T BE REACHED >>>=20 >>> ORA2PG.DAROLD.NET [1] took too long to respond. >>>=20 >>> Try:" >>>=20 >>> thank you. >>>=20 >>> Bach-Nga >>>=20 >>> No one in this world is pure and perfect.=C2=A0 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 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 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 Oracle to PostgreSQL. >>>=20 >>> https://ora2pg.darold.net/documentation.html >>>=20 >>> Thanks & Regards, >>> SHREEYANSH DBA TEAM >>> www.shreeyansh.com [2] >>>=20 >>> On Fri, Jan 11, 2019 at 9:53 PM Pepe TD Vo > wrote: >>>=20 >>>> Hi Experts, >>>>=20 >>>> Is there a best tool for me to copying data from Oracle to >>>> PostgreSQL? >>>> The Oracle db named is Cidr and had a few schemas, each schemas >>>> owned 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? >>>>=20 >>>> thank you for your helps. >>>>=20 >>>> v/r, >>>>=20 >>>> Bach-Nga >>>>=20 >>>> No one in this world is pure and perfect.=C2=A0 If you avoid people fo= r >>>> 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 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 Gingold) >>>> **Live simply **Love generously **Care deeply **Speak kindly. >>>> *** Genuinely rich *** Faithful talent *** Sharing success >>=20 >>=20 >>=20 >> Links: >> ------ >> [1] http://ora2pg.darold.net/ >=20 >> [2] http://www.shreeyansh.com/ >=20 >=20 >=20 > Links: > ------ > [1] https://ora2pg.darold.net/documentation.html =20 ------=_Part_758899_1853853052.1547670918952 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Need to download oracl-fdw?  It's hard to go thru= so many processes, need to download, transfer information to somewhere, as= k for permission to burn into a CD/DVD, burn a CD/DVD, fil= e a paperwork to move software from CD/DVD to server.

Is there a way I can use those s= oftware already downloaded and transferred to the server?
I am asking where should = I install ora2pg?  on oracle db server or postgres db server?  I = saw DBD-Oracle-1.52 tar and DBD-pg-2.19.3.tar, http://ora2pg-samrat.blogspot.com/ but didn't say which one = is install on which?

th= e information is not really clear and may you help me out?

thank you.

 
<= /b>
Bach-Nga

No one in this w= orld 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 i= n as much as he had four legs, a tail, and barked, I admit he was, to all o= utward appearances. But to those who knew him well, he was a perfect gentle= man (Hermione Gingold)

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


On Wednesday,= January 16, 2019 3:23 PM, "gilberto.castillo@etecsa.cu" <gilberto.casti= llo@etecsa.cu> wrote:



Answer interline.

El 2019-01-16 15:17, Pepe TD Vo escribi=C3=B3:
> sorry to ask, what is oracle_fdw

oracle_fdw is extension for pg (foreign data wrapper)

> do I need to download this oracle_fdw an= d where should I install it,
> on oracle server or pos= tgresql server?

You can to install in = pg server or wherever.
>
> thank= you.
>
> Bach-Nga
>
> No one in this world is pure and perfect.=   If you avoid people for
> their mistakes you wi= ll be alone. So judge less, love and forgive
> more.> To call him a dog hardly seems to do him justice thou= gh in as much as
> he had four legs, a tail, and barke= d, I admit he was, to all outward
> appearances. But t= o those who knew him well, he was a perfect
> gentlema= n (Hermione Gingold)
> **Live simply **Love generously= **Care deeply **Speak kindly.
> *** Genuinely rich **= * Faithful talent *** Sharing success
>
>  On Wednesday, January 16, 2019 3:09 PM, "gilberto.castillo@etecsa.cu"
> <= ;gilberto.castillo@etecsa.cu> wrot= e:
>
> Hello
&= gt;
>  You may to use oracle_fdw
>
> El 2019-01-16 15:05, Pepe TD Vo escribi=C3= =B3:
>> I am able to download the ora2pg but I don'= t understand how it
>> install. According to the do= cument I found on net that yum install
>> perl-DBD,= perl-dev, and perl-CPAN and all
>> oracle-instantc= lient18.3-sqlplus-18.3.0.0.0-1.x86_64.rpm,
>> oracl= e-instantclient18.3-basic-18.3.0.0.0-1.x86_64.rpm,
>&g= t; oracle-instantclient18.3-basic-18.3.0.0.0-1.x86_64.rpm,
>> oracle-instantclient18.3-devel-18.3.0.0.0-1.x86_64.rpm,
>> oracle-instantclient18.3-devel-18.3.0.0.0-1.x86_64.rpm.<= br clear=3D"none">>>
>>    * I ca= n't find the ora2pg18.2 on gzip or zip but bz2.  With this
> file
>> I can't unzip it because the se= rver didn't have this feature.  Can I
>> use o= ra2pg.19.1.tar.gz instead of version 18?
>>  &= nbsp; * 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.  If y= ou avoid people for
>> their mistakes you will be a= lone. So judge less, love and forgive
>> more.
>> To call him a dog hardly seems to do him justice tho= ugh 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=
>> gentleman (Hermione Gingold)
= >> **Live simply **Love generously **Care deeply **Speak kindly.
>> *** Genuinely rich *** Faithful talent *** Sharing s= uccess
>>
>>  On Frid= ay, January 11, 2019 11:42 AM, Shreeyansh Dba
>> &l= t;shreeyansh2014@gmail.com> wrote:
>>
>> This site works for us, t= here might be a security restriction at
> your
>> end.
>>
>= > Thanks & Regards,
>> SHREEYANSH DBA TEAM>> www.shreeyansh.com [2]
>>=
>> On Fri, Jan 11, 2019 at 10:04 PM Pepe TD Vo &l= t;pepevo@yahoo.com>
> wrote:
>>
>>> Yes, I need migrate al= l the objects including tables, functions,
>>> t= riggers, procedures from Oracle to Postgres.  Oracle is on one
>>> server and Postgres is on another server.
>>>
>>> https= ://ora2pg.darold.net/documentation.html [1]doesn't work. "
>>>
>>> THIS SITE CAN=E2=80=99T = BE REACHED
>>>
>>> O= RA2PG.DAROLD.NET [1] took too long to respond.
>>&g= t;
>>> Try:"
>>> >>> thank you.
>>>
>>> Bach-Nga
>>>
>>> No one in this world is pure and perfect.  If= you avoid people for
>>> their mistakes you wil= l 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 admit he was, to all
>>= > outward appearances. But to those who knew him well, he was a
>>> perfect gentleman (Hermione Gingold)
>>> **Live simply **Love generously **Care deeply **Speak kindl= y.
>>> *** 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 b= est tool for data migration
>>> from Oracle to P= ostgreSQL.
>>>
>>> <= a shape=3D"rect" href=3D"https://ora2pg.darold.net/documentation.html" targ= et=3D"_blank">https://ora2pg.darold.net/documentation.html
>>>
>>> Thanks & Regards,>>> SHREEYANSH DBA TEAM
>>= > www.shreeyansh.com [2]
>>>
>>> On Fri, Jan 11, 2019 at 9:53 PM Pepe TD Vo <= pepevo@yahoo.com>
> wrote:
&g= t;>>
>>>> Hi Experts,
>>>>
>>>> Is there a best tool= for me to copying data from Oracle to
>>>> P= ostgreSQL?
>>>> The Oracle db named is Cidr a= nd 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 sch= emas from
>>>> Oracle? Or each schema will be= come one of the postgreSQL database?
>>>> >>>> thank you for your helps.
>>>>
>>>> v/r,
>>>>
>>>> Bach-Nga
>>>>
>>>> No one in th= is world is pure and perfect.  If you avoid people for
>>>> their mistakes you will be alone. So judge less, love a= nd forgive
>>>> more.
>&= gt;>> To call him a dog hardly seems to do him justice though in as m= uch
>>>> as he had four legs, a tail, and bar= ked, I admit he was, to all
>>>> outward appe= arances. But to those who knew him well, he was a
>>= ;>> perfect gentleman (Hermione Gingold)
>>&g= t;> **Live simply **Love generously **Care deeply **Speak kindly.
>>>> *** Genuinely rich *** Faithful talent *** Sha= ring success
>>
>>
>>
>> Links:
&= gt;> ------
>> [1] http://ora2pg.darold.net/
>
>> [2] http://www.shreeyansh.com= /
>
>
>= ;
> Links:=


------=_Part_758899_1853853052.1547670918952--