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 1ghzlq-0001v6-Ai for pgsql-admin@arkaria.postgresql.org; Fri, 11 Jan 2019 16:34:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ghzlp-0002V3-0w for pgsql-admin@arkaria.postgresql.org; Fri, 11 Jan 2019 16:34:57 +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 1ghzlo-0002Uw-Gf for pgsql-admin@lists.postgresql.org; Fri, 11 Jan 2019 16:34:56 +0000 Received: from sonic316-13.consmr.mail.bf2.yahoo.com ([74.6.130.123]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghzll-0002YO-6b for pgsql-admin@lists.postgresql.org; Fri, 11 Jan 2019 16:34:55 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1547224491; bh=f06DfnW5rK+ZjnVTsjdVZZ0HriV06TS++j3FbG4sZtk=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=dN6Kl+rI2ewhHj8yn1bz59J7h8zQuhl6SqeAeMyMwC5dm8g4REPVcmDgjhxXJN5c5vlThe7pYrqLd0kTPQJM/YYsxaoGhG7fNDpKVP0pGXB2dkfX2MAYNU9lBWjaWEHE6eKfEtNHMCwS5YiUM/1cYwge87hVLNxNQZpxN5yz5LATDqYrhI3t/hComjkW05WZrWIJyfkAvbN6iubBQwGRr6cFHXKOonf08KLxB1vO0l3kIoS0L8sg+st5MOVLvUNGPd1jJioIGwPFcS4btJiR+z+xndwzGiZCLPp+iltqoLGj2310U8kpAvd5r5mf6iPsYkONErsidbkMEvGSNkGTNg== X-YMail-OSG: KQJ7LsMVM1mRCiqzNXa2MsFjijDWlUzUJYymZfOO56WavAvcblUTbLrXPiYMTpH xDFPlyZSf2Id5FTTdhBb1P1ff3SeA.zTqZk1.D6BL8U7oVI9qSEVgnXfX5WqmNSgFXK0uIlhRmSS qSzb_zucyc6q23MaTtFtbB110yWsGlBAMLgAVMxIzYuYJGrAnHGjHAMssr7cnx.RFXj4WQkFaxEZ dqIL9Gg.P_6XdwAJ8QPVkuVDAqAkLUKajM8CpXvg00B9rT93dq.htisIOAmPr1g9p0.u09RNf20J .88NX4OYJDJuaNB4CDFk6h5eGLDa65jdKoDS5fdfueAGAk_kVUIwVWQq04skg0kaAJKoAZ9fHwxd SVhv6Fz44wiTliZqP2YQhPEwGfNnkEdKb5JMMxwAEjcxauqhNS.Ayd.Dt1TzdbgUEjbt9S9sjCHA z6LcUdeD1FtbUYj1lDyFmpSnIFyV5VIo0GnrQ8NihPV0_UJBndYJvzmzZhn4cyuEBpV4z42Bz0tS 7lRPSDfMY4yPO7yk_DEoW4srAhQn7hoITxfVFuf2MQyKMyhHzuEBQ5.LLJxSgzZQB6rUx1jG0zii r1FP1fmVtdOR2XnwwBCPUHvCTnh3N_y_HwxTHYGjy3VgGP8XZAXL0PJP5Gzgr6UP0D3KYUnzRJ2v _q58QZCyktR3PMeZRYaB6fO8LtzE0jmFTOPcCO9291qfEmyeogejk14NLRlhugPeLj3CxQWVkRMH 8MUCPBXoxUI5spN.9IbG0j7rpn41o6GR2TyV28AnaytTTRV87YMu3QwZNEiHexoQk61wyQ2r7SfD DjlErDx9Hdz0nhz1q2zA7fCeqzNNoVtOYkDQjEbZDh8PgzCTJwm1OajOAwrGwdADjEjbPiwJTjJG 7CPvXzyQl664Em9qdsaeeS_n84mmUbQQgJ7eAl6cP9.25u5801p2BNL9_.ApHV6IZhpOUbI8Go1K WlBDObfOj.jbdV_wQctQl.EqW61DMrpF5zox8UmEgONSy1EOs1hrnNEJGt5.0jmeY4KeRnGQfFNa VuNv8G2yaWFow1ScRTdMj0fV3jvLxbT0caBDrAw_r6rQsvMFdRQb8LzpRQnIA4gTlEKqbcKAwWxj tz6_5XS0Bubg- Received: from sonic.gate.mail.ne1.yahoo.com by sonic316.consmr.mail.bf2.yahoo.com with HTTP; Fri, 11 Jan 2019 16:34:51 +0000 Date: Fri, 11 Jan 2019 16:34:49 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Shreeyansh Dba Cc: Pgsql-admin Message-ID: <560782983.17074510.1547224489903@mail.yahoo.com> In-Reply-To: References: <1382151693.17038706.1547223778133.ref@mail.yahoo.com> <1382151693.17038706.1547223778133@mail.yahoo.com> Subject: Re: Copying Data from Oracle to PostgreSQL MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_17074509_524541646.1547224489901" 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: 14283 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_17074509_524541646.1547224489901 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 ------=_Part_17074509_524541646.1547224489901 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Yes, I need migrate all the objects including tables, = functions, triggers, procedures from Oracle to Postgres.  Oracle is on= one server and Postgres is on another server.  

=
<= a href=3D"https://ora2pg.darold.net/documentation.html">https://ora2pg.daro= ld.net/documentation.html doesn't work. "

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

ora2pg.darold.net took too long to respond.
=
Try:"
<= /div>
 

=
thank you.

Bach-Nga

No one= in this world is pure and perfect.  If you avoid people for their mis= takes 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 outwar= d 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


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


Hi,
You can use ora2pg which is one of th= e best tool for data migration from Oracle to PostgreSQL.

https://ora2pg.darold.n= et/documentation.html 

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


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

Hi Experts,

Is there a best tool for me to cop= ying 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.  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.  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 kn= ew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely ri= ch *** Faithful talent *** Sharing success
<= /div>


------=_Part_17074509_524541646.1547224489901--