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 1ghzaP-0000v7-Cd for pgsql-admin@arkaria.postgresql.org; Fri, 11 Jan 2019 16:23:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ghzaO-0003ML-52 for pgsql-admin@arkaria.postgresql.org; Fri, 11 Jan 2019 16:23:08 +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 1ghzaN-0003ME-Rs for pgsql-admin@lists.postgresql.org; Fri, 11 Jan 2019 16:23:07 +0000 Received: from sonic304-11.consmr.mail.bf2.yahoo.com ([74.6.128.34]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghzaL-0002ly-A9 for pgsql-admin@lists.postgresql.org; Fri, 11 Jan 2019 16:23:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1547223782; bh=W5EdMXuInrkHHPN6m5mZyhy342hZxfyd/UvLSC7Vau0=; h=Date:From:Reply-To:To:Subject:References:From:Subject; b=cAVOAgmMWlSkT3oAQDZboV/5DpgWKzjZiISAidWFVeyPlzKeiaZpl7oYhyUeOAygQYr+KdV/1gtyPCBdFElebti2ZfQrQi0zDtPnhi7SE3b8CHwknID0hjC0VCly9+pXsROpSUvNrEeFReFLEceNejrJ3zNzoeW8PQtdUlJC7TMtE4R3Dk0goyQablrksMDbsfu8UxghcbV6pSrFG4mwZUB6PLdKW99xqu2L9Zg7an8tujtyWJvtDkqEo/57qboy03Ah9z7N8Efw+gmXhCJuA/lPnLOoTtLOUPdlG62fzQYqlAdkE2spIV+tisqqJXaRcS90nmuFSG7UwlnmnFUbsw== X-YMail-OSG: 0zmTlnsVM1ml3ed3ALa5krWrk3dZelIVu0v7PfwfvNLiQEjdQ.eLl1KXLKetGDe P8REIz3oVA.hks0CQkNGTMW1O1uKMkOWzang7GYNWx.NkNslwhu1GRTkqNH4wRrIDWsauyDklzIK wLWsrKN0Df2gFIchvaxU2TVLD4tuklsh1tb4PbF2ecSeKZoxTJRz4mGTouP8Zi6d.1iwJlu6AUDi eAXiTQvfTT0iORpouVsmSg1YMHCNoPn09OA4aqDZkzArLHqP1DeEO06Xxn2LVNsxf5mYgtNRyyIg xMpH4aScyA58y20N_Z4nruRcKz_4a2SayXoIumbgLYinESCq4YqrUypL79862p6xMD_K7x8QVcOz hfHWSMlpHwZyxHo7bZSJ3xeX37RJ01kHQnUd3hOZuauHzA0HIOr3O3JIoTbckha3HR1sJ_aHKT0t 9D.Zvijdw_muFtodA21j_N3n8rx0fbUqeG3oc9zmUhgDyYb6aIQ2EqmnYqcJjho6IZNxPBdsBhIl ppCCV8qJil_eedu8O8TeT9aO41DCEQt489dlbjfqCu1DWdsspiMbs073jtsmkEUOqJi6TTR1BegX kxx3V1O058zTeL69bkIJuPcR5.Kjtgaac5VuYtzS2sbkeB91cCQWe.Ab3cKWwq_k9229kgBKCLYX JUtdFUpS3FRPIWF0wXEN2jgfql59sb8i7UvDYioFb55BJH4XVKtaGeIOTLtElOPIHU1yUErmKap_ cgqHCcXh5EE2bChoD.dl75t7_407VeTWNhjE0KsuHW5Fj72HsIX_scoiUcVWnf54DY9ENfwYDaVQ a69zioFYq.sRNOPNpsx_iB4frViu95GrxgT4nI44H7_Lzz6Pzpx6iNpZLu_91QA1t0sefV9Ww_Mg jPipjMqpPzpk.T4s.GQDaGboqfvOUtb2NKD1qOX8vSKM35KPgtPRRcb8ri2m6JvQvj3dfVYKSrz6 0_AjJbQS87Npiz.5ObzDhLY5xGFm0FB_6s2e4ahxQn4U45.W.VFoBdGNskJDNChtJ7oZk4oPCtgj yzOKbk.PyPhtBesrj1GH2xISG2NHMRzX_FgC1fFZ5OKZdQvVEl6.O Received: from sonic.gate.mail.ne1.yahoo.com by sonic304.consmr.mail.bf2.yahoo.com with HTTP; Fri, 11 Jan 2019 16:23:02 +0000 Date: Fri, 11 Jan 2019 16:22:58 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Pgsql-admin Message-ID: <1382151693.17038706.1547223778133@mail.yahoo.com> Subject: Copying Data from Oracle to PostgreSQL MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_17038705_1918859206.1547223778132" References: <1382151693.17038706.1547223778133.ref@mail.yahoo.com> 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: 5889 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_17038705_1918859206.1547223778132 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 ------=_Part_17038705_1918859206.1547223778132 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Hi Experts,

Is th= ere a best tool for me to copying data from Oracle to PostgreSQL? &nbs= p;
The Orac= le db named is Cidr and had a few schemas, each schemas owned their own tab= les, procedures, triggers, functions.  If I create a database on Postg= res, 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 forgi= ve 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 ki= ndly.
*** Genuinely rich *** Faithful talent *** Sharing suc= cess
------=_Part_17038705_1918859206.1547223778132--