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 1gjreX-0001dN-8a for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jan 2019 20:19:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gjrdX-0000uc-Qd for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jan 2019 20:18:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjrdX-0000uU-I7 for pgsql-admin@lists.postgresql.org; Wed, 16 Jan 2019 20:18:07 +0000 Received: from sonic316-14.consmr.mail.bf2.yahoo.com ([74.6.130.124]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjrdU-0001aD-5F for pgsql-admin@lists.postgresql.org; Wed, 16 Jan 2019 20:18:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1547669880; bh=fozYCJ1MaIXCNJ8LpkASqgeyyrelDQMJotS6uXR8a8E=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=cr3D33lAMOXrY7/dXoZxVvAMgsivTnC7Ujeunhzew9iiRglmMhOw64opd9X6c3Vr2psKI7TJB5mOSfMca4pPTYNICf41Geux5vGn4Vp/AbZl8gHJUPr4bNuSUB/cji0wA6Pm5uSzpY9KBFgE9iD524VHLhK8IrfFX7287BIZO7cro+OO8k2torcrBaOnQUrfqetRBeP5JH1cwprnSQ72CQ+uRrMvcSG7DlAuxidG3LBigcPobbNlaLrMOJGsnpB8gpkHuvFroScalA8VQORe0b1swRM0n9Kbs85cJSbfCV53LHBjtfFVl6SBfki7nawvKloJ1oGLjtL6X78vS8p4DQ== X-YMail-OSG: uLEuz6cVM1ntPd7Zpz.5_djQAesjHwHLfjREy2I2HG6EyYNwYh8dQdNve6mS9Tt DPrenvQxvVlvTacOGv6aE39lLGBhHynjHH6bk1R29XSTxZoz1QpUZiF5wmasHbgwaL.p12hY85RY JSukf0TsV_DvxbGaFkTUkyMBAhq09XeXL7Q3QdoIgHj9ht9l1.oPDmiyKFpWPuAIowEbqEwrrjr0 EBkS8Ny7yX9tHlt0cPWa7dy0VvhEfCks_c1j9lCnChRINUNNKWCqwRHUw8SlY99vAW_xX8YW2pKx t1k9AK.NwfEBTPHJHvjo_yHjvRdkwV5iPJ7KAs2kI45tTMICj_ytYSsncRU6h9pO440MiE8qbIhV Pzn6byFreFMcIoQFWPkrpJvCY2hQH89xM1H9fucrw2rgCnPGZcVmBZxAmUOcvuyz8RxPHzGo4yZl YVrJQNEmAs9qM_iekkv1Hdo2hu7PnbtEUchFAdSS0ggkMHHVVPbL6.AJev8vsjPTWciU40d4hFWu dtgrmLK033qlDjr8mIjNEZYJv_Fgtikb5r4yKLgHArXkm9PDITyHFkK1C1aWiDNLBk3y32kc1sed m0nzTlfTK5T2yxK._tkFgKFnos0k.De1TzAfixAFaFm.2wIYgNK6aneVxdJ51iuPDwT_hbUcQq5o DCSOTqk0CZN01bw22H3S2hjf2Z9mJtyXNk6U8hR2X6T_nVfNRbaNrKVG1gD0ybGBu.eGUosMiRXa gCxpZ.I4Fgiv9PLkJzaF5lOuusDdeyWeGJIlZy215oeJXRFPcCQ5BlCqcBydx.9cy8NputGSUjWo s11TVk76yv6sxbh.dm8r4cJWzUepEJ4ND.tptmUo15uTPeN7d05468GChAngXLreU4DXI9NJlRfk yS8Lao0_5fq0pSaoHwKH0emQ4I6R9fPRoY4wYFbRkGHGGVmsnl7TlPUQsEJVvhJWF8pRttGw7uz_ yWMw06rQ8_xLiX38BmosPKz7ngK8ly9kDozohu4o24c8PvC9VMWdMU76QswCJ5vWATYmfvWzZNsh VD9J3WIIr.umEowKAGnZyb4J9p_fwf9xyhcw1q88M4YVbjX.XwOkDJiehsqekIHjhzNMdGWfyq_7 iUjgC Received: from sonic.gate.mail.ne1.yahoo.com by sonic316.consmr.mail.bf2.yahoo.com with HTTP; Wed, 16 Jan 2019 20:18:00 +0000 Date: Wed, 16 Jan 2019 20:17:55 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: "gilberto.castillo@etecsa.cu" Cc: Shreeyansh Dba , Pgsql-admin Message-ID: <1492323826.781728.1547669875527@mail.yahoo.com> In-Reply-To: <8b2bd545ff5c18410548e6e2fcb99a4e@etecsa.cu> 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> Subject: Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_781727_1488969114.1547669875525" 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: 16734 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_781727_1488969114.1547669875525 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable sorry to ask, what is=C2=A0oracle_fdwdo I need to download this oracle_fdw = and where should I install it, on oracle server or postgresql server? thank you.=C2=A0 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 Wednesday, January 16, 2019 3:09 PM, "gilberto.castillo@etecsa.cu" <= gilberto.castillo@etecsa.cu> wrote: =20 Hello =C2=A0 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 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=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=C2=A0 * Where should I install ora2pg, in the oracle db serv= er 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 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 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 >=20 >=20 > Links: > ------ > [1] http://ora2pg.darold.net/ > [2] http://www.shreeyansh.com/ =20 ------=_Part_781727_1488969114.1547669875525 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
sorry to ask, what is&nb= sp;oracle_fdw=
do I need to download this oracle_fdw and where should I install it, on= oracle server or postgresql server?

thank you. 

Bach-Ng= a

No one in this world is pure and= perfect.  If you avoid people for their mistakes you will be alone. S= o 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 appearanc= es. But to those who knew him well, he was a perfect gentleman (Hermione Gi= ngold)

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


On Wednesday, January 16, 20= 19 3:09 PM, "gilberto.castillo@etecsa.cu" <gilberto.castillo@etecsa.cu&g= t; wrote:


Hello

  You may to use = oracle_fdw

El 2019-01-16 15:05, Pepe T= D 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-D= BD, perl-dev, and perl-CPAN and all
> oracle-instantcl= ient18.3-sqlplus-18.3.0.0.0-1.x86_64.rpm,
> oracle-ins= tantclient18.3-basic-18.3.0.0.0-1.x86_64.rpm,
> oracle= -instantclient18.3-basic-18.3.0.0.0-1.x86_64.rpm,
> or= acle-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.
>
>     * I can't find the ora2pg1= 8.2 on gzip or zip but bz2.  With this file
> I c= an't unzip it because the server didn't have this feature.  Can I
> use ora2pg.19.1.tar.gz instead of version 18?
>     * Where should I install ora2pg, in the o= racle 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 you avoid people for
> their mistakes you will be alone. So judge less, love and forgiv= e
> more.
> 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 knew him well, he was a perfec= t
> gentleman (Hermione Gingold)
>= ; **Live simply **Love generously **Care deeply **Speak kindly.
> *** Genuinely rich *** Faithful talent *** Sharing success
>
>  On Friday, January 11, 201= 9 11:42 AM, Shreeyansh Dba
> <shreeyansh2014@gmail.com> wrote:
>
> This site works for us, there might be a security restri= ction at your
> end.
>
> Thanks & Regards,
> SHREEYANSH DBA = TEAM
> www.shreeyansh.com [2]
> <= br clear=3D"none">> 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, funct= ions,
>> triggers, procedures from Oracle to Postgr= es.  Oracle is on one
>> server and Postgres i= s on another server.
>>
>>= https://ora2pg.darold.net/documentation.html doesn't wo= rk. "
>>
>> THIS SITE CAN= =E2=80=99T BE REACHED
>>
>>= ; ORA2PG.DAROLD.NET [1] took too long to respond.
>>= ;
>> Try:"
>>
>> thank you.
>>
&g= t;> Bach-Nga
>>
>> No o= ne in this world is pure and perfect.  If you avoid people for
>> their mistakes you will be alone. So judge less, love a= nd forgive
>> more.
>> To c= all 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 h= im well, he was a
>> perfect gentleman (Hermione Gi= ngold)
>> **Live simply **Love generously **Care de= eply **Speak kindly.
>> *** Genuinely rich *** Fait= hful talent *** Sharing success
>>
>> On Friday, January 11, 2019 11:31 AM, Shreeyansh Dba
>> <shreeyansh2014@gmail.com= > wrote:
>>
>> Hi,<= br clear=3D"none">>> You can use ora2pg which is one of the best tool= for data migration
>> from Oracle to PostgreSQL.>>
>> https:= //ora2pg.darold.net/documentation.html
>>
>> Thanks & Regards,
>> SHR= EEYANSH DBA TEAM
>> www.shreeyansh.com [2]
>>
>> 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 copying data from Oracle to
>>> PostgreSQL?>>> The Oracle db named is Cidr and had a few sch= emas, each schemas
>>> owned their own tables, p= rocedures, triggers, functions.  If I
>>> c= reate a database on Postgres, how do I copy all schemas from
>>> Oracle? Or each schema will become one of the postgreSQL d= atabase?
>>>
>>> tha= nk you for your helps.
>>>
&g= t;>> v/r,
>>>
>>&= gt; Bach-Nga
>>>
>>>= No one in this world is pure and perfect.  If you avoid people for>>> their mistakes you will be alone. So judge les= s, 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
>>> p= erfect gentleman (Hermione Gingold)
>>> **Live s= imply **Love generously **Care deeply **Speak kindly.
>= ;>> *** Genuinely rich *** Faithful talent *** Sharing success
>
>
>
> Links:
> ------
> = [1] = http://ora2pg.darold.net/

> [2]
http://www.shreeyansh.com/



------=_Part_781727_1488969114.1547669875525--